user24986
0
Q:

tsql utf to local time

select CONVERT(datetime, SWITCHOFFSET(dateTimeField, DATEPART(TZOFFSET, 
dateTimeField AT TIME ZONE 'Eastern Standard Time')))
1
select 
 [MyUtcDate] + getdate() - getutcdate()
from [dbo].[mytable]
-1

New to Communities?

Join the community