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
    makkynm
  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
    scottf
  3. Dates – Calculate week number based on date
    mwiegand > Public > Knime Forum Support > Dates – Calculate week number based on date
    mwiegand
  4. Lab 1 - 05 Date and Time Manipulations
    bojesphob > Public > Lab 1 > Lab 1 - 05 Date and Time Manipulations
    bojesphob
  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
    kellytm2
  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
    deborah_santos
  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
    malgorzatagirda
  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
    kzhqtt
  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
    lina3
  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
    lina3