<--- --------------------------------------------------------------------------------------- ---- Blog Entry: Getting Only The Date Part Of A Date/Time Stamp in SQL Server (Revisited) Author: Ben Nadel / Kinky Solutions Link: http://www.bennadel.com/index.cfm?dax=blog:963.view Date Posted: Sep 21, 2007 at 8:01 AM ---- --------------------------------------------------------------------------------------- ---> DATEADD( DD, 0, DATEDIFF( DD, 0, date_created )