Date&Time Part Extractor

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

Date&Time column

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

Extracted fields

Define date or time fields to extract and set column names.

• Field: The type of field to extract.
  • Year: The year number will be extracted and appended as an integer column.
  • Year (Week-based): 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.
  • 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.
  • Millisecond: If checked, the millisecond fraction of second will be extracted as number in range [0-999] and appended as an integer column.
  • Microsecond: If checked, the microsecond fraction of second will be extracted as number in range [0-999,999] and appended as an integer column.
  • Nanosecond: If checked, the nanosecond fraction of second will be extracted as number in range [0-999,999,999] and appended as an integer column.
  • 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.
• Column name: The name of the column populated with the values of the selected field.

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).

Views

This node has no views

Workflows

• (Optional)_Linear_RegressionKNIME Hub
• [ON] PEX ROTINAS 2024KNIME Hub
• 00 Send Reporting_vMediumKNIME Hub
• 01 - Email Database Data PreparationKNIME Hub
• 01 Data and Time and DatabasesKNIME Hub
• Show all 1424 workflows

Links

• How to group date by dayby qqilihq on 2021-11-01

  forum.knime.com/p/138399
• Grouping date by month errorby ipazin on 2022-11-08

  forum.knime.com/p/174494
• Nodo fecha de cargaby gonhaddock on 2022-05-11

  forum.knime.com/p/156601
• Day of the week based on dateby HansS on 2023-09-27

  forum.knime.com/p/236237

Developers