Extract Date&Time Fields

Extracts the selected fields from a Local Date, Local Time,
Local Date Time or Zoned Date Time column and appends their values as
corresponding integer or string columns.

Options

Column Selection

Date&Time column

A Local Date, Local Time, Local Date Time or
Zoned Date Time column whose fields to extract.

Date Fields

Year

If checked, the year will be extracted and
appended as an integer column.

Year (week-based)

If checked, the year based on the week will be
extracted and appended
as an integer column. Depending on the
selected locale, week 1 of a
year may already start in the previous
year, or week 52 of a year may
last until the next year (e.g.,
30th
Dec 2010 belongs to week 1 of
year 2011 (locale en-US), so the
extracted
Year (week-based)
would be 2011 while the extracted
Year
would be 2010).

Quarter

If checked, the quarter of year will be extracted
as a number in range [1-4] and appended as an integer column.

Month (number)

If checked, the month of year will be extracted
as a number in range [1-12] and appended as an integer column.

Month (name)

If checked, the month of year will be extracted
as a localized name and appended as a string column.

Week

If checked, the week of year will be extracted as
a number in range [1-52] and appended as an integer column. A
partial week at the beginning of a year is handled according to the
chosen locale.

Day of year

If checked, the day of year will be extracted as
a number in range [1-366] and appended as an integer column.

Day of month

If checked, the day of month will be extracted as
a number in range [1-31] and appended as an integer column.

Day of week (number)

If checked, the day of week will be extracted as
a number in range [1-7] and appended as an integer column. The
numbering is based on the chosen locale.

Day of week (name)

If checked, the day of week will be extracted as
a localized name and appended as a string column.

Time Fields

Hour

If checked, the hour of day will be extracted as
a number in range [0-23] and appended as an integer column.

Minute

If checked, the minute of hour will be extracted
as a number in range [0-59] and appended as an integer column.

Second

If checked, the second of minute will be
extracted as a number in range [0-59] and appended as an integer
column.

Subsecond

If checked, the fraction of second will be extracted as number and
appended as an integer column. The desired time unit can be
specified.

milliseconds: extract as milliseconds, range [0-999]

microseconds: extract as microseconds, range [0-999,999]

nanoseconds: extract as nanoseconds, range [0-999,999,999]

Time Zone Fields

Time zone name

If checked, the unique time zone name will be
extracted as a non-localized name and appended as a string column.

Time zone offset

If checked, the time zone offset will be
extracted as a localized, formatted number and appended as a string
column.

Localization

Locale

The locale that governs the localization of
output strings (month, day of week, time zone offset) and takes care
of local calendrical characteristics (week and day of week
numbering).

Installation

To use this node in KNIME, install
KNIME Core
from the following update site:

KNIME 4.0

Wait a sec! You want to explore and install nodes even faster? We highly recommend our
NodePit for KNIME
extension for your KNIME Analytics Platform.

Developers

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.

Contact

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 mail@nodepit.com,
follow @NodePit on Twitter,
or chat on Gitter!

Please note that this is only about NodePit. We do not provide general support for KNIME — please use the KNIME forums instead.

NodePit is the world’s first search engine that allows you to easily search, find and install KNIME nodes and workflows. Explore the KNIME community’s variety. Start mining and follow @NodePit on Twitter.