Skip to content
Advertisement

Convert timestamp/date time from UTC to EST Oracle SQL

I have a field with a date/time value like this:

It’s in UTC. In the query how can I convert this to EST?

I’m trying something like this but it throws an error.

Advertisement

Answer

I had to tweak it slightly to get it to work on my database, but this worked:

The key is the “at time zone” syntax.

User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement