Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • mlauber71
  • Spaces
  • Public
  • _date_time_formats_meta_collection
WorkflowWorkflow

A meta collection about handling data and time functions in KNIME, R and SQL (including databases and big data systems)

Date Time Knime Node R
+4
mlauber71 profile image

Last edited: 

Drag & drop
Like
Download workflow
Copy short link
Workflow preview
A meta collection about handling data and time functions in KNIME, R and SQL (including databases and big data systems) Node Guide - Date and Time Manipulation https://www.knime.com/nodeguide/etl-data-manipulation/date-and-time-manipulation Blog - Date & Time Integration https://www.knime.com/blog/the-new-date-time-integration Blog - Explore Using Date&Time Formats in KNIME plus Best Practices https://www.knime.com/blog/explore-date-time-formats-best-practices simple date string conversions - dd/MM/yyyy, d/M/yyyy https://kni.me/w/wuMcGsOBLuR7U37A Various operations with dates as date value, string and number https://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_date_string_format?u=mlauber71 Deal with (messy) Time formats containing AM/PM distinctions https://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_date_time_am_pm_format?u=mlauber71 various date and time formats including R https://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_r_date_formats_extended?u=mlauber71 Examples how to insert date columns into KNIME data sets https://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_date_columns_insert?u=mlauber71 Using the current date as Filename https://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_current_date_as_file_name?u=mlauber71 Enter your own pattern and us the help file https://forum.knime.com/t/string-to-date/27684/2?u=mlauber71 https://docs.oracle.com/javase/8/docs/api/java/time/format/DateTimeFormatter.html Hive (Big Data) also comes with a lot of Date and Time functions https://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_hive_school_of?u=mlauber71 Convert an Excel date number (starting from 1900-01-01) into a KNIME date variable https://forum.knime.com/t/como-cambiar-una-fecha-que-viene-en-excel-en-formato-texto-que-se-muestra-como-un-numero-44075-a-formato-fecha-en-knime/27849/2?u=mlauber71 Play around with SQLite and Date and Time functions https://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_db_sqlite_timestamp?u=mlauber71 H2 database - JOIN by TIMESTAMP https://forum.knime.com/t/efficient-way-of-doing-a-join-where/27474/3?u=mlauber71

External resources

  • Various operations with dates as date value, string and number
  • Deal with (messy) Time formats containing AM/PM distinctions
  • various date and time formats including R
  • Examples how to insert date columns into KNIME data sets
  • Using the current date as Filename
  • Enter your own pattern and us the help file
  • Hive (Big Data) also comes with a lot of Date and Time functions
  • Convert an Excel date number (starting from 1900-01-01) into a KNIME date variable
  • Node Guide - Date and Time Manipulation
  • Blog - Date & Time Integration
  • Play around with SQLite and Date and Time functions
  • H2 database - JOIN by TIMESTAMP
  • Blog - Explore Using Date&Time Formats in KNIME plus Best Practices
  • simple date string conversions - dd/MM/yyyy, d/M/yyyy

Used extensions & nodes

All required extensions are part of the default installation of KNIME Analytics Platform version 4.5.1

No known nodes available

Loading deployments
Loading ad hoc executions

Legal

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

Discussion
Discussions are currently not available, please try again later.

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits