topic Re: Converting Seconds since the epoch to datetime in Discussions

Converting Seconds since the epoch to datetime

jfsilves — Tue, 03 Mar 2020 19:21:56 GMT

I have a column of data representing datetime stamps that is stored in seconds since the epoch (1 Jan 1970).

How can I make JMP interpret these integers as datetime stamps?

Re: Converting Seconds since the epoch to datetime

Jeff_Perkinson — Tue, 03 Mar 2020 19:42:29 GMT

You'll need to add 01Jan1970 to each of those.

You can use 01Jan1970 as an unquoted constant to do that.

For example:

today70=1583246337; //03Mar2020 in seconds since 01Jan1970;

today_jmp=today70 + 01Jan1970; //add number of seconds from 01Jan1904

format(today_jmp, "mm/dd/yyyy");

Results:

/*:

"03/03/2020"

Note: you can use any date, not just 01Jan1970, as a constant like that.

Re: Converting Seconds since the epoch to datetime

Jeff_Perkinson — Tue, 03 Mar 2020 20:45:58 GMT

Also, you'll find more information about this topic in .