Convert(Date,GETDATE())
Select * from myTable where
Convert(Date,ModifiedDate) = Convert(Date,GETDATE())
In 2005:
CONVERT(CHAR(10), GETDATE(), 1)
Select * from myTable where
CONVERT(CHAR(10), ModifiedDate, 1) = CONVERT(CHAR(10), GETDATE(), 1)
Old School:
cast(floor(cast(ModifiedDate as float))as datetime)
No comments:
Post a Comment