Getting Only The Date Part Of A Date/Time Stamp in SQL Server (Revisited) 

DATEDIFF( DD, 0, date_created )

For Cut-and-Paste