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

[#1]

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

[#2]

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.

[#3]

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

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