Datum bez vremena

DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0)