Check out example codes for "convert utc to est sql". 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')))

Learn ReactJs, React Native from akashmittal.com