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

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

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

Week numbers different date systems - KNIME Forum (76641) - week starts on Monday or Sunday
https://forum.knime.com/t/extract-date-time-fields/76641/2?u=mlauber71

use KNIME Java-Snippet to create date and time variables
https://hub.knime.com/-/spaces/-/~wg_b2zEDiY0V9RGE/current-state/
https://forum.knime.com/t/date-type-workflow-variable/23119/11?u=mlauber71

External resources

• use KNIME Java-Snippet to create date and time variables
• Week numbers different date systems - KNIME Forum (76641) - week starts on Monday or Sunday
• H2 database - JOIN by TIMESTAMP
• Play around with SQLite and Date and Time functions
• Blog - Date & Time Integration
• Node Guide - Date and Time Manipulation
• Convert an Excel date number (starting from 1900-01-01) into a KNIME date variable
• Hive (Big Data) also comes with a lot of Date and Time functions
• Enter your own pattern and us the help file
• Using the current date as Filename
• Examples how to insert date columns into KNIME data sets
• various date and time formats including R
• Deal with (messy) Time formats containing AM/PM distinctions
• Various operations with dates as date value, string and number