Icon

kn_​example_​date_​string_​format

Various operations with dates as date value, string and number

see what you can do with dates as data values, strings and numbers. You can transform them and store them as String or number and reuse them as timestamps (eg. for files to be exported).


https://forum.knime.com/t/converte-date/13035/3?u=mlauber71yes there would be several ways to do it, with a Java Snippet. Trying to keep it nice and knimey here ... Various operations with dates as date value, string and number Explore Date&Time in KNIME & Get Best Practiceshttps://www.knime.com/blog/explore-date-time-formats-best-practices create tableconvert to Dateadd_zero_daylength_day_of_monthDay of monthwith leading zeronew_datelength_monthadd_zero_monthMonth (number)with leading zeroconvert to Datenew_date_timemy_date_timenew_date_string_oracledd-MMM-yyUpper Case Table Creator String to Date&Time Rule Engine String Manipulation String Manipulation String Manipulation String Manipulation Rule Engine String Manipulation String to Date&Time String to Date/Time(legacy) String to Date/Time(legacy) Number ToString (PMML) Date&Time to String String Manipulation Extract Date&TimeFields https://forum.knime.com/t/converte-date/13035/3?u=mlauber71yes there would be several ways to do it, with a Java Snippet. Trying to keep it nice and knimey here ... Various operations with dates as date value, string and number Explore Date&Time in KNIME & Get Best Practiceshttps://www.knime.com/blog/explore-date-time-formats-best-practices create tableconvert to Dateadd_zero_daylength_day_of_monthDay of monthwith leading zeronew_datelength_monthadd_zero_monthMonth (number)with leading zeroconvert to Datenew_date_timemy_date_timenew_date_string_oracledd-MMM-yyUpper CaseTable Creator String to Date&Time Rule Engine String Manipulation String Manipulation String Manipulation String Manipulation Rule Engine String Manipulation String to Date&Time String to Date/Time(legacy) String to Date/Time(legacy) Number ToString (PMML) Date&Time to String String Manipulation Extract Date&TimeFields

Nodes

Extensions

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: 2018-12-27
On NodePit since: 2019-10-03
Last update: 2024-11-23
Created with KNIME version: v4.7.7
Tags: dateformatsstringnumberknime

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

Try NodePit Runner!