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

DATEADD( DD, 0, DATEDIFF( ** ) )

For Cut-and-Paste