T-SQL -- remove the time from a datetime

DATEADD(d,DATEDIFF(d,0,GETDATE()),0)