Hub
NodeNode / Manipulator

Extract Date&Time Fields (deprecated)

Other Data Types Time Series Transform Streamable

This node has been deprecated and its use is not recommended. Please search for updated nodes instead.

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 (deprecated) node is part of this extension:

Related workflows & nodes

  1. 日時情報抽出 - Extract Date&Time Fields
    Japanese 日本語 Makkynm
    +5
    Extract Date&Time Fieldsの紹介用Workflowです。 年月日など、Date&Time型のコラムから好きな形で日時情報を取得できるNodeです。 This…
    makkynm > Public > Intermediate > I126_ExtractDateTimeFields
  2. Date String Conversion Without Leading Zeroes
    Date
    This workflow demonstrates how you can ingest string-formatted dates that may not have le…
    scottf > Public > ForumWorkflows > 2019 > 10 > StringConversionWithoutLeadingZeroes
  3. Dates – Calculate week number based on date
    mwiegand > Public > Knime Forum Support > Dates – Calculate week number based on date
  4. Lab 1 - 05 Date and Time Manipulations
    bojesphob > Public > Lab 1 > Lab 1 - 05 Date and Time Manipulations
  5. 05 Date and Time Manipulation - Solution
    Date Time
    Solution to an exercise for date and time manipulation. Perform data manipulation operati…
    kellytm2 > 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…
    deborah_santos > 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…
    malgorzatagirda > 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…
    kzhqtt > Public > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Solutions > 05 Date and Time Manipulation - Solution
  9. 05 Date and Time Manipulation - Solution
    Date Time
    Solution to an exercise for date and time manipulation. Perform data manipulation operati…
    lina3 > Public > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Exercises > 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…
    lina3 > Public > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Solutions > 05 Date and Time Manipulation - Solution