Tuesday, September 15, 2015

T-sql :: Change just DATE part of a DATETIME

DECLARE @dt DATETIME SET @dt = GETDATE() SELECT DATEADD(dd, DATEDIFF(dd, @dt, '2015-06-01'), @dt)

Share/Bookmark

No comments: