SQL for UTC Conversion

Question

I have 2 columns in a table as follows,

TIMESTAMP                          TIMEZONE
2020-08-20T02:36:52.000+0000       PST
2020-08-20T02:36:52.000+0000       GMT
2020-08-20T02:36:52.000+0000       CST

Now I want to convert those timestamp column data to UTC column.. But the conversion should be based on the timestamp and the timezone column. I can do it on a dataframe. But I have to do it on SQL.

Please help on how to use both the columns to derive respective UTC Timestamp data for each record.

... because many dbms products have their own date/time functions, non-ANSI SQL compliant. — jarlh, Aug 25 '20 at 07:00
You should avoid time zone abbreviations, as they can be ambiguous. For example, "CST" can mean "Central Standard Time", "Cuba Standard Time", or "China Standard Time". — Matt Johnson-Pint, Aug 25 '20 at 18:20

score 1 · Answer 1 · answered Aug 25 '20 at 14:12

1

Got the answer for this,

SELECT to_utc_timestamp(timestamp, timezone) from tablename;

This will sort the issue..

answered Aug 25 '20 at 14:12

Lokesh

87
2
11

SQL for UTC Conversion

1 Answers1