Hub
WorkflowWorkflow

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

DateTimeKnimeNodeR
+4
Markus Lauber profile image
Draft Latest edits on 
Drag & drop
Like
Download workflow
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 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
Loading deploymentsLoading ad hoc jobs

Used extensions & nodes