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?
You'll need to add 01Jan1970 to each of those.
You can use 01Jan1970 as an unquoted constant to do that.
today70=1583246337; //03Mar2020 in seconds since 01Jan1970;
today_jmp=today70 + 01Jan1970; //add number of seconds from 01Jan1904
Note: you can use any date, not just 01Jan1970, as a constant like that.
Also, you'll find more information about this topic in Using dates, times, datetimes and durations in JMP.
There are no labels assigned to this post.