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