Check out example codes for "tsql utf to local time". It will help you in understanding the concepts better.

Code Example 1

select CONVERT(datetime, SWITCHOFFSET(dateTimeField, DATEPART(TZOFFSET, 
dateTimeField AT TIME ZONE 'Eastern Standard Time')))

Code Example 2

select 
 [MyUtcDate] + getdate() - getutcdate()
from [dbo].[mytable]

Learn ReactJs, React Native from akashmittal.com