Parse Date&Time

An alternative to the standard String to Date&Time node that can be used where the case of the supplied date/time string does not conform to that required by the Locale, or where dates may be in a variety of formats (with variation of separators and/or a mix of numeric and named months) whilst all conforming to a common sequence of day, month and year.

With the standard String to Date conversion nodes, if the Locale dictates that months are Jan, Feb, Mar etc, then the conversion would will fail if the months presented are JAN, FEB, MAR. This was the use case that the Parse Date&Time component was written, but the use case has been expanded a little... :-)

If both date and time are present, then currently they must follow the sequence DATE then TIME

Times may be entered in either 24 hour (0-23) or am/pm 1-12 format. These are the formats I am familiar with. If there is demand for alternative time formats, please contact me via the KNIME forum.

@takbb Brian Bates 22 May 2023

Input ports

1. Type: Table
   Input Date
   Data Table containing one or more String columns to be converted to Local DateTime or Local Date

Output ports

1. Type: Table
   Output Table
   Date Table with additional columns appended