select * from TABLE where DATETIME_FIELD between CAST(GETDATE() AS DATE) AND DATEADD(DAY, 1, CAST(GETDATE() AS DATE))

Tagged with:  

Comments are closed.