686724_en-US

liliconcom

Adding hours to existing date/time column

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

Automation and ScriptingRe: Adding hours to existing date/time column

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