Database column Mapping-Date Column

KNIME Analytics Platform
1

I have a column in excel which is of 12/01/2024 (MM/DD/YYYY) format, when reading in KNIME the output is shown as 2024-12-01. But I want the column to be present in same format as like in excel also having Datatype as “Local Date”.

when I convert the date column to specific format MM/DD/YYYY, the datatype of knime node output is string but I want to convert the date column to Local Date data type inorder to push it into database table, but whenever I type cast it to date type it is showing date as yyyy-mm-dd format. Can someone help how to retain the date data type along with the format (mm/dd/yyyy) of the column

Kindly help here.

2

Hey @Anantha_Bhairav

Welcome to the KNIME community.
Currently the KNIME default when parsing a date string to local date is the format YYYY-MM-DD.
If you wish to change the format in order for someone to read it, KNIME Analytics Platform currently only provides the option to bring it back to the string type.
That being said we are planing to build a node similar to the number format manager but for dates, which would allow you to change the appearance of a local date type.
Pushing the local date to a database shouldn’t be any problem right now.

All the best
Linus

4 Likes