Hub
NodeNode / Manipulator

Extract Date&Time Fields

Other Data Types Time Series Transform Streamable
Drag & drop
Like
Copy short link

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.

Node details

Input ports
  1. Type: Table
    Input table
    Input table.
Output ports
  1. Type: Table
    Output table
    Output table containing the extracted fields as appended columns.

Extension

The Extract Date&Time Fields node is part of this extension:

Related workflows & nodes

  1. 05 Date and Time Manipulation - Solution
    Date Time
    Solution to an exercise for date and time manipulation. Perform data manipulation operati…
    knime > Education > Self-Paced Courses > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Solutions > 05 Date and Time Manipulation - Solution
  2. 05 Date and Time Manipulation - Solution
    Date Time
    Solution to an exercise for date and time manipulation. Perform data manipulation operati…
    tqthanh168 > Public > Self-Paced Courses > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Solutions > 05 Date and Time Manipulation - Solution
  3. 05 Date and Time Manipulation - Solution
    Date Time
    Solution to an exercise for date and time manipulation. Perform data manipulation operati…
    falconjd37 > Public > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Solutions > 05 Date and Time Manipulation - Solution
  4. 05 Date and Time Manipulation - Solution
    Date Time
    Solution to an exercise for date and time manipulation. Perform data manipulation operati…
    l22barne > Public > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Solutions > 05 Date and Time Manipulation - Solution
  5. 05 Date and Time Manipulation - Solution
    Date Time
    Solution to an exercise for date and time manipulation. Perform data manipulation operati…
    avubi > Public > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Solutions > 05 Date and Time Manipulation - Solution
  6. 05 Date and Time Manipulation - Solution
    Date Time
    Solution to an exercise for date and time manipulation. Perform data manipulation operati…
    hariish > Public > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Solutions > 05 Date and Time Manipulation - Solution
  7. 05 Date and Time Manipulation - Solution
    Date Time
    Solution to an exercise for date and time manipulation. Perform data manipulation operati…
    attmahareeq > Public > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Solutions > 05 Date and Time Manipulation - Solution
  8. 05 Date and Time Manipulation - Solution
    Date Time
    Solution to an exercise for date and time manipulation. Perform data manipulation operati…
    km_tan > Public > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Solutions > 05 Date and Time Manipulation - Solution
  9. 05 Date and Time Manipulation
    Date Time
    Exercise for date and time manipulation. Perform data manipulation operations that are sp…
    ricardolalmeida > Public > ExercisesDW > 05 Date and Time Manipulation
  10. 05 Date and Time Manipulation - Solution
    Date Time
    Solution to an exercise for date and time manipulation. Perform data manipulation operati…
    halverdog > Public > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Solutions > 05 Date and Time Manipulation - Solution