topic Re: Time zone conversion in Discussions

Time zone conversion

Sri — Sat, 10 Jun 2023 23:22:03 GMT

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,

txnelson — Tue, 10 Nov 2020 07:34:34 GMT

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"));

Sri — Tue, 10 Nov 2020 07:54:14 GMT

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 — Tue, 10 Nov 2020 11:39:00 GMT

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

Craige_Hales — Tue, 10 Nov 2020 14:39:27 GMT

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.