Viewing post 1 (of 1 total)
I think it is the easiest way
select * from Track
where
Track.Track_Open_Date = CAST(CONVERT(char(10),GETDATE(),102) AS smalldatetime))
November 26, 2003 at 11:44 pm
#483864