Home Forums SQL Server 7,2000 T-SQL Truncating Date RE: Truncating Date
Andrew Deren
Mr or Mrs. 500
Points: 597
More actions
April 12, 2006 at 5:16 pm
#632251
I found a solution on google:
SELECT DATEADD(dd, DATEDIFF(dd,0,@x), 0)
but that seems odd to do datediff and dateadd to get the result.
I wish there was a built in function for that.