How to convert PST timezone to UTC timezone in Hive?

[#1]

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

[#2]

Hi @JT Ng

I've answered on your other post.