Parses the strings in the selected columns and converts them into Date&Time cells. The expected format can be selected from a number of commonly used formats or specified manually (see section "Type and Format Selection").
Since dates may contain localized terms such as month or weekday names, you can additionally specify a locale.
A template ("format string") that specifies how to interpret the input. This template may contain placeholders for different descriptions of month names, weekday names, month and day numbers, year numbers etc., as well as other non-alphabetic characters that are expected to appear in the input string.
Commonly used placeholders are
y for year,
M for month,
d for day of month,
H for hours,
m for minutes and
seconds. A full list of placeholders can be found below.
The count of an individual placeholder letter defines the expected format. For example, a weekday can be represented by its full name ("Monday"), a short name ("Mon") or a narrow name ("M"). Commonly used expressions are:
yymatches years relative to the year 2000: "21" will be interpreted as "2021".
MMmatches month numbers like "01",
MMMmatches short month names like "Jan",
MMMMmatches full month names like "January".
dmatches day numbers like "5" and "05".
yyyy.MM.dd HH:mm:ss.SSSparses dates like "2001.07.04 12:08:56.000"
yyyy-MM-dd'T'HH:mm:ss.SSSZparses dates like "2001-07-04T12:08:56.235-0700"
yyyy-MM-dd'T'HH:mm:ss.SSSXXX'['VV']'parses dates like "2001-07-04T12:08:56.235+02:00[Europe/Berlin]"
Placeholders can be declared as optional by wrapping them in square brackets. This is useful if it is unclear whether the input contains a certain field or not. For example:
HH:mm:ss[.SSS]parses times like "12:08:56.123" and "12:08:56"
yyyy-MM-dd'T'HH:mm[:ss[.SSS]]parses dates like "2001-07-04T12:08:56.235", "2001-07-04T12:08:56" and "2001-07-04T12:08"
Optional placeholders can also be useful if different formats are to be expected. For example,
[MMMM][MMM] dd, yyyy matches both "April 02, 2021" and "Apr 02, 2021". Note that
this will also match when no month description is given whatsoever.
The full list of supported placeholders is given below. You can find a full, technical specification here.
y: year of era
D: day of year
M: month in year (context sensitive)
L: month in year (standalone form)
d: day of month
Q: quarter of year
q: quarter of year
Y: week based year
w: week of week based year
W: week of month
E: day of week
e: localized day of week
c: localized day of week
F: week of month
a: am/pm of day
h: clock hour of am/pm (1-12)
K: hour of am/pm (0-11)
k: clock hour of am/pm (1-24)
H: hour of day (0-23)
m: minute of hour
s: second of minute
S: fraction of second
A: milli of day
n: nano of second
N: nano of second
V: time zone ID
z: time zone name
O: localized zone offset
X: zone offset (
x: zone offset
Z: zone offset
p: pad next
': escape for text
'': single quote
[: optional section start
]: optional section end
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.
A zipped version of the software site can be downloaded here.
Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.Try NodePit Runner!
Do you have feedback, questions, comments about NodePit, want to support this platform, or want your own nodes or workflows listed here as well? Do you think, the search results could be improved or something is missing? Then please get in touch! Alternatively, you can send us an email to email@example.com, follow @NodePit on Twitter or botsin.space/@nodepit on Mastodon.
Please note that this is only about NodePit. We do not provide general support for KNIME — please use the KNIME forums instead.