T-SQL -- remove the time from a datetime DATEADD(d,DATEDIFF(d,0,GETDATE()),0)