question Re: How can I convert PST time to UTC time in Hive? in Archives of Support Questions (Read Only)

How can I convert PST time to UTC time in Hive?

jeanette75007 — Tue, 08 Aug 2017 03:58:25 GMT

Hello experts;

I have this query is getting PST time in Hive but how can I convert this PST time to UTC time? Please help

select from_unixtime(unix_timestamp()-1*60*60*4, 'yyyyMMddHH') as pst_time;

Thanks in advance

Re: How can I convert PST time to UTC time in Hive?

ssahi — Wed, 09 Aug 2017 07:06:24 GMT

hi @JT Ng

Hive supports functions to_utc_timestamp() and from_utc_timestamp() to make this easier. Please see the language manual here for these functions including examples of how to invoke them.

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF

Re: How can I convert PST time to UTC time in Hive?

jeanette75007 — Wed, 09 Aug 2017 20:38:48 GMT

hi Sahi,

Thanks for your posts. I am able to use to_utc_timestamp() and from_utc_timestamp() functions.

Thanks