<--- --------------------------------------------------------------------------------------- ---- Blog Entry: Getting Only the Date Part of a Date/Time Stamp in SQL Server Author: Ben Nadel / Kinky Solutions Link: http://www.bennadel.com/index.cfm?dax=blog:122.view Date Posted: Jul 7, 2006 at 6:05 PM ---- --------------------------------------------------------------------------------------- ---> CAST( FLOOR( CAST( GETDATE() AS FLOAT ) ) AS DATETIME )