Hub
Pricing About
WorkflowWorkflow

01 Date and Time Manipulation - Solution

DateTimeString to date&timeModify timeExtract date&time fields
terbe profile image
Draft Latest edits on 
Oct 23, 2020 3:31 PM
Drag & drop
Like
Download workflow
Workflow preview
Solution to an exercise for data and time manipulation. Transform date and time values from string to the dedicated Date&Time format. Remove redundant digits from the timestamps. Extract the day of the week from the dates, and aggregate the data. CHECK YOUR ANSWERS: 1. The highest number (9382) of last reviews were given on Sunday 2. The lowest number (3554) of last reviews were given on Thursday

External resources

  • Modify Date/Time/Time Zone Nodes
  • Extract Date&Time Fields Node
  • String to Date&Time Node
Loading deploymentsLoading ad hoc jobs

Used extensions & nodes

Created with KNIME Analytics Platform version 4.4.0
  • Go to item
    KNIME Base nodesTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.4.0

    knime

Legal

By using or downloading the workflow, you agree to our terms and conditions.

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits