Icon

_​date_​time_​formats_​meta_​collection

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

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 Manipulationhttps://www.knime.com/nodeguide/etl-data-manipulation/date-and-time-manipulationBlog - Date & Time Integrationhttps://www.knime.com/blog/the-new-date-time-integrationVarious operations with dates as date value, string and numberhttps://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_date_string_format?u=mlauber71 Deal with (messy) Time formats containing AM/PM distinctionshttps://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_date_time_am_pm_format?u=mlauber71 various date and time formats including Rhttps://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_r_date_formats_extended?u=mlauber71 Examples how to insert date columns into KNIME data setshttps://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_date_columns_insert?u=mlauber71 Using the current date as Filenamehttps://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_current_date_as_file_name?u=mlauber71Enter your own pattern and us the help filehttps://forum.knime.com/t/string-to-date/27684/2?u=mlauber71https://docs.oracle.com/javase/8/docs/api/java/time/format/DateTimeFormatter.htmlHive (Big Data) also comes with a lot of Date and Time functionshttps://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_hive_school_of?u=mlauber71Convert an Excel date number (starting from 1900-01-01) into a KNIME date variablehttps://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=mlauber71Play around with SQLite and Date and Time functionshttps://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_db_sqlite_timestamp?u=mlauber71H2 database - JOIN by TIMESTAMPhttps://forum.knime.com/t/efficient-way-of-doing-a-join-where/27474/3?u=mlauber71Week numbers different date systems - KNIME Forum (76641) - week starts on Monday or Sundayhttps://forum.knime.com/t/extract-date-time-fields/76641/2?u=mlauber71use KNIME Java-Snippet to create date and time variableshttps://hub.knime.com/-/spaces/-/~wg_b2zEDiY0V9RGE/current-state/https://forum.knime.com/t/date-type-workflow-variable/23119/11?u=mlauber71 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 Manipulationhttps://www.knime.com/nodeguide/etl-data-manipulation/date-and-time-manipulationBlog - Date & Time Integrationhttps://www.knime.com/blog/the-new-date-time-integrationVarious operations with dates as date value, string and numberhttps://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_date_string_format?u=mlauber71 Deal with (messy) Time formats containing AM/PM distinctionshttps://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_date_time_am_pm_format?u=mlauber71 various date and time formats including Rhttps://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_r_date_formats_extended?u=mlauber71 Examples how to insert date columns into KNIME data setshttps://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_date_columns_insert?u=mlauber71 Using the current date as Filenamehttps://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_current_date_as_file_name?u=mlauber71Enter your own pattern and us the help filehttps://forum.knime.com/t/string-to-date/27684/2?u=mlauber71https://docs.oracle.com/javase/8/docs/api/java/time/format/DateTimeFormatter.htmlHive (Big Data) also comes with a lot of Date and Time functionshttps://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_hive_school_of?u=mlauber71Convert an Excel date number (starting from 1900-01-01) into a KNIME date variablehttps://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=mlauber71Play around with SQLite and Date and Time functionshttps://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_db_sqlite_timestamp?u=mlauber71H2 database - JOIN by TIMESTAMPhttps://forum.knime.com/t/efficient-way-of-doing-a-join-where/27474/3?u=mlauber71Week numbers different date systems - KNIME Forum (76641) - week starts on Monday or Sundayhttps://forum.knime.com/t/extract-date-time-fields/76641/2?u=mlauber71use KNIME Java-Snippet to create date and time variableshttps://hub.knime.com/-/spaces/-/~wg_b2zEDiY0V9RGE/current-state/https://forum.knime.com/t/date-type-workflow-variable/23119/11?u=mlauber71

Nodes

  • No nodes found

Extensions

  • No modules found

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: m_lauber
Created at: 2020-09-28
On NodePit since: 2020-09-28
Last update: 2024-05-18
Created with KNIME version: v4.7.8
Tags: datetimeknimenoderconvertpatternstringto

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!