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.
... View more