Date-Time Formats

jfsilves — Mon, 11 May 2020 16:41:22 GMT

I have date-time data in a column of form:

2020-04-30T17:29:48.967-04:00

This data was loaded from a database. JMP recognizes it only as a string of characters.

How can I convert this into a JMP datetime format?

P.S. I do not care about the timezone (-04:00).

Re: Date-Time Formats

txnelson — Mon, 11 May 2020 17:16:36 GMT

Here is a little script that should convert the column to a JMP date time value

names default to here(1);
dt=current data table();
for each row(
	:date = substr(:date, 1, length(:date)-length(word(-1,:date,"-"))-1);
);

dt:date << data type(numeric)<<modeling type(continuous);
dt:date << format("yyyy-mm-ddThh:mm:ss");

Just replace the values of :Date to whatever your column name is

topic Re: Date-Time Formats in Discussions

Date-Time Formats

Re: Date-Time Formats