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