date - SQL Server Forums

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 2000 Forums

Transact-SQL (2000)

date

Author

Topic

kemi2299
Starting Member

41 Posts

Posted - 2008-04-18 : 10:55:07

hi,

could you pls help in defining date statement in tsql

UPDATE #stemp42
SET start_date_flag=1
WHERE Admiss_Dt>='01-jan-2004'
AND Admiss_Dt < DATE('day');

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-04-18 : 11:33:21

UPDATE #stemp42
SET start_date_flag=1
WHERE Admiss_Dt>='01-jan-2004'
AND Admiss_Dt < GETDATE()

E 12°55'05.25"
N 56°04'39.16"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-04-19 : 03:28:57

What does DATE('day') do?

UPDATE #stemp42
SET start_date_flag=1
WHERE Admiss_Dt>='01-jan-2004'
AND Admiss_Dt < dateadd(day,datediff(day,0,GETDATE()),0)

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources