Tag Info

New answers tagged

-1

I always use this TSQL command. -- the utc value declare @utc datetime = '20/11/2014 05:14' -- the local time select DATEADD(hh, DATEDIFF(hh, getutcdate(), getdate()), @utc) It is very simple and it does the job.



Top 50 recent answers are included