Converting Seconds since the epoch to datetime

[#1]

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?

[#2 · Accepted solution]

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.

[#3]

Also, you'll find more information about this topic in Using dates, times, datetimes and durations in JMP.