topic Re: Datetime format confusion (looking for equivalent of python's datetime.strptime) in Discussions

Datetime format confusion (looking for equivalent of python's datetime.strptime)

mvanderaa1 — Mon, 10 Mar 2025 16:04:15 GMT

I'm sure this has been asked many times, but I did not find a good solution.

I have a column (let's call it time_col) with a timestamp in the format 2024-06-28T13:47:03

Looking at the documentation I figured I should use Format, something like:

Format(:time_col, "Format Pattern", "<YYYY><-><MM><-><DD><T><hh><:><mm><:><ss>" )

But this does not give any result.

In python it would be:

datestr = '2024-06-28T13:47:03'
datetime_object = dt.strptime(datestr, '%Y-%m-%dT%H:%M:%S')

hope someone can help me out

Re: Datetime format confusion (looking for equivalent of python's datetime.strptime)

mvanderaa1 — Mon, 10 Mar 2025 16:18:26 GMT

I see now that this format is actually supported by JMP. I didn't find it because I was looking for a date format while my data type was set to "character" instead of "numeric".

I suppose my question is still valid for other string formats though.

Re: Datetime format confusion (looking for equivalent of python's datetime.strptime)

txnelson — Mon, 10 Mar 2025 16:23:19 GMT

JMP has a built in format for this time structure. Use

informat(:timeEcol,"yyyy-mm-ddThh:mm:ss")