Getting Data In

Converting PST to UTC

purushot1234
New Member

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.

Labels (1)
Tags (1)
0 Karma
1 Solution

manjunathmeti
SplunkTrust
SplunkTrust

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

View solution in original post

0 Karma

manjunathmeti
SplunkTrust
SplunkTrust

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
0 Karma

purushot1234
New Member

Hi Manjunathmeti, Thank you very much for this clarification

Regards
Puru

0 Karma
Get Updates on the Splunk Community!

Set Up More Secure Configurations in Splunk Enterprise With Config Assist

This blog post is part 3 of 4 of a series on Splunk Assist. Click the links below to see the other ...

Observability Highlights | November 2022 Newsletter

 November 2022Observability CloudEnd Of Support Extension for SignalFx Smart AgentSplunk is extending the End ...

Enterprise Security Content Update (ESCU) v3.54.0

The Splunk Threat Research Team (STRT) recently released Enterprise Security Content Update (ESCU) v3.54.0 and ...