Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

How to convert PST timezone to UTC timezone in Hive?

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

JN

1 REPLY 1

Guru

Hi @JT Ng

I've answered on your other post.