MSSQL TODAY Function

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

roughly twice as efficient as:

CONVERT(DATETIME, CONVERT(varchar(10),@time, 120))

October 27, 2010 В· admin В· No Comments
Posted in: MSSQL

Leave a Reply