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.