how to add the time for the month where i give the

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

how to add the time for the month where i give the

Author

Topic

celv
Starting Member

6 Posts

Posted - 2014-07-04 : 06:16:38

how to add the time for the month where i give the condition

my table is

CREATE TABLE [dbo].[aten](
[Id] [int] NULL,
[Name] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Status] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Section] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Intime] [datetime] NULL,
[Date] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Outtime] [datetime] NULL
) ON [PRIMARY]

i need to total in Intime for a month

celv

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2014-07-04 : 06:38:49

How does the intime value look like?

Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources