Hub
Pricing About
WorkflowWorkflow

01 Date and Time Manipulation - Solution

DateTimeString to date&timeModify timeExtract date&time fields
P
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

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

Used extensions & nodes

Created with KNIME Analytics Platform version 4.7.0 Note: Not all extensions may be displayed.

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