topic Re: Converting PST to UTC in Getting Data In

Converting PST to UTC

purushot1234 — Wed, 30 Sep 2020 04:48:49 GMT

Hello,

I am trying to convert current PST time to UTC. I have written below code.
But when I compare with current time in UTC, there is a difference between two. They are not same.

Please let me know if I am missing anything

STRT_TIME = 01-APR-2020 20:30:21 ( Current PST time search from google)

| eval START_TIME= "01-APR-2020 20:30:21"
| eval myUTCtimeEpoch=round(strptime(START_TIME." PST","%d-%B-%Y %H:%M:%S %Z"))
| eval myUTCtime=strftime(myUTCtimeEpoch,"%d-%B-%Y %H:%M:%S %Z")
| eval current_date_utc = strftime(round(now()),"%m/%d/%Y %H:%M:%S %Z")
| table START_TIME current_date myUTCtime

Result:

STRT_TIME = 01-APR-2020 20:30:21
myUTCtime = 02-April-2020 04:30:21 UTC
current_date_utc = 04/02/2020 03:30:21 UTC

Above, I was expecting current_date_utc and myUTCtime to be same but there is 1 hour difference between them.

Re: Converting PST to UTC

manjunathmeti — Wed, 30 Sep 2020 04:51:41 GMT

Pacific Standard Time(PST) is 8 hours behind the Coordinated Universal Time (UTC). Looking at the value of current_date_utc, it looks like your system is using Pacific Daylight Time (PDT) which is 7 hours behind UTC. You need to use PDT instead of PST in time conversion. Google PST vs PDT to understand differences.

| eval START_TIME= "01-APR-2020 20:30:21"
| eval myUTCtimeEpoch=round(strptime(START_TIME." PDT","%d-%b-%Y %H:%M:%S %Z"))
| eval myUTCtime=strftime(myUTCtimeEpoch,"%d-%B-%Y %H:%M:%S %Z")
| eval current_date_utc = strftime(round(now()),"%m/%d/%Y %H:%M:%S %Z")
| table START_TIME current_date myUTCtime

Re: Converting PST to UTC

purushot1234 — Thu, 02 Apr 2020 15:57:05 GMT

Hi Manjunathmeti, Thank you very much for this clarification

Regards
Puru