I am currently using: sample_start_time AT TIME ZONE 'UTC' AT TIME ZONE 'Eastern Standard Time' AS sample_start_time_est from: Convert Datetime column from UTC to local time in select statement
I know there are bunch of solutions on converting timezone to timezone, but what I'd like to know whether we can get eastern time without making conversion from our local time.
149 If your local date time is say Eastern Standard Time and you want to convert from UTC to that, then in Azure SQL and SQL Server 2016 and above, you can do:
Note that there are more than one time zone name that contains the word "Eastern", so simple matches like this will break. For example, there is "SA Eastern Standard Time" and "AUS Eastern Standard Time".
Each time zone is separated by an hour to the time zones that border it. For example, Central Standard Time (CST) borders Eastern Standard Time (EST). So 2PM in CST would be 3PM in EST.
What time is 2 pm eastern time in central time? - Answers
Given that your requirement is to use the "Eastern zone," I'd use US/Eastern, but note: It's just a link to America/New_York. This file in Paul Eggert's tz repo says those links are to link "old" names (such as US/Eastern) to current names. "Old" may well mean "deprecated" in this context. Paul Eggert is the TZ Coordinator for IANA's Time Zone list, so this is a clearly canonical source. Given ...
java - Correct ZoneId for eastern time (ET): either "US/Eastern" or ...
I am using a query to get some application Received Date from Oracle DB which is stored as GMT. Now I have to convert this to Eastern standard/daylight savings time while retrieving. I am using the...