Tej's: SQL find out two date between intervals

Monday, July 21, 2008

select getdate()
select dateadd("yy",-1,getdate())

dd - day
mm - month
yy - year

-1 - add -1 day/month/year in gurrent date.

Tej's said...: select CAST( FLOOR( CAST( getDate() AS FLOAT ) ) AS DATETIME )

for Date only --->

01/28/2009 16:23:00

--> 01/28/2009 00:00:00; January 27, 2009 at 12:52 PM