UTC to EST Time Conversion Table UTC to EST in 12-hour (AM/PM) time format. I suspect the server's timezone is UTC, which means that SWITCHOFFSET has to add 4 hours to the EST time to get the proper UTC time.Convert timezones and find the best time for your meeting in Eastern Standard Time (North America) is 5 hours behind from the UTC universal time. If inputdate is provided as a datetimeoffset value, then AT TIME ZONE clause converts it into the target time zone using the time zone conversion rules. When inputdate is provided without offset information, the function applies the offset of the time zone assuming that inputdate is in the target time zone. This is clearly explained in the documentation :Ĭonverts an inputdate to the corresponding datetimeoffset value in the target time zone. It can't do any because it has no idea what the source offset is. In this case, AT TIME ZONE simply appends the offset without making any conversions. Is equivalent to select GETDATE() at time zone 'Eastern Standard Time'

This means that select CURRENT_TIMESTAMP at time zone 'Eastern Standard Time'

It returns a local datetime without any offset indication. CURRENT_TIMESTAMP is equivalent to GETDATE(). The problem is using CURRENT_TIMESTAMP in the first place.

Use a single : select cast(SYSDATETIMEOFFSET() at time zone 'Eastern Standard Time' as datetime)

Utc time to est