Basic date time conversion

[metaresolve]

Hi,

My date is in the following format: “MM/DD/YYYY HH:MM” then AM or PM.

How do I translate that into a date/time field that I can work with? I’d like to make graphs.

Thanks,

[mlauber71]

You could first convert it to string and then use the

String to Date&Time

Node and select the proper string pattern. If you want more operations with dates you could seek inspiration here:

Various operations with dates as date value, string and number

[metaresolve]

My date format doesn’t appear in the en-US options. The example workflow you gave me chose a date format from de-DE. When I click Guess data type and format, it tells me “No suitable format found!”

I tried putting in MM/DD/YYYY HH:MM but the node broke. Then, I tried using the String to Date/Time (legacy) node and putting the date format in there, but I came out with dates that were all in December when my dates were in April in the column I was trying to convert.

How do I convert the date-time format I have into something usable?

Thanks,

[mlauber71]

You might have to choose the format by hand and if this does not work to do additional conversions discussed here:

Messy Date & Time String Reformatting

Have you tried the string to Date/Time conversion with this format which should cover AM and PM dd/MM/yyyy hh.mm aa I think the node can also auto guess the right format. Also you can refer to.: https://www.knime.com/blog/the-new-date-time-integration I am not at my trusted machine right now so I can’t test it.

Extract time with PM/AM

Hi, I think the format h:mm' 'a should work for you. Kind regards Alexander

Parsing date time using string to date

I changed the format to: dd/MM/yy hh:mm:ss a and now it seems to work We had a similar discussion before and I came up with a little bit of a messy solution. Maybe as an inspiration if further problems occur: datetime_test.knwf (11.3 KB)

Maybe KNIME can improve the date and time nodes to handle these am/pm formats better.

[mlauber71]

@metaresolve

I tried putting in MM/DD/YYYY HH:MM but the node broke.

This string does seem to do the trick:

MM/dd/yyyy’ ‘hh:mm’ 'a

though I am not 100% happy with the AM/PM implementation.

Deal with (messy) Time formats containing AM/PM distincions – mlauber71

[metaresolve]

Thank you so much. A combination of those links got me to be able to convert the date into something I can use.