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

DATEADD(
	DD,
	0,
	DATEDIFF(
		DD,
		0,
		date_created
	)

For Cut-and-Paste