topic Adding hours to existing date/time column in Discussions

Adding hours to existing date/time column

cchueng — Fri, 13 Oct 2023 04:03:10 GMT

Hello,

I am attaching a table here with the first column showing UTC date\time. How do I use JSL to generate a column called Taiwan Time by adding 8 hours to the 1st column?

Thanks, Cryz

Re: Adding hours to existing date/time column

txnelson — Fri, 13 Oct 2023 04:24:26 GMT

Use the In Hours() function to add the hours.

:RunFinishUTCDateTime + In Hours( 8 )

JMP Date/Time values are measured in the number of seconds. Therefore, the following formula would also work

:RunFinishUTCDateTime + 8 * 60 * 60