Getting Only the Date Part of a Date/Time Stamp in SQL Server 

CAST(
	FLOOR( CAST( GETDATE() AS FLOAT ) )
	AS DATETIME
)

For Cut-and-Paste