TSQL Date String from DateTime

SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))

via http://blogs.x2line.com/al/archive/2006/02/17/1458.aspx