cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
Sri
Sri
Level I

Time zone conversion

I have data in the UTC time format. Can someone tell me how to convert this data to my local time (Pacific Standard Time)? Thanks,

4 REPLIES 4
txnelson
Super User

Re: Time zone conversion

If your UTC time is 7:00 am so Pacific Standard Time will be 8 hours earlier....

names default to here(1);
UTCtime = informat("07:00:00", "h:m:s");
Pacific time = UTCtime - in hours(8);
show(UTCtime, format(Pacific time,"h:m:s"));
Jim
Sri
Sri
Level I

Re: Time zone conversion

Thanks for your response. A quick follow-up? Is there a solution that can accommodate time change (i.e., to daylight saving and back)?

txnelson
Super User

Re: Time zone conversion

There is not a built in function for this.  You will need to compensate for day light saving by checking on the date of the measurement in your JSL 

Jim
Craige_Hales
Super User

Re: Time zone conversion

Good point. Historical measurements, converted to local time... Does not matter if you are currently in daylight or standard time.

 

You might want to consider converting your local time to UTC instead, depending on your audience.

Craige