writing column with date time into oracle causes trouble

KNIME Analytics Platform
1

Dear all,

in attached workflow I am reading a record with a colum string containg 2025-04-16.
In a column expression node I am converting it into format yyyy-mm-ddTHH:mm:ss.
Next node string to date&time is converting this string into date.
ā†’ all outputs are looking great.
test 11 to Knime.knwf (27.5 KB)

Then I write the table to an Oracle database.

When checking Oracle table from outside Knime e.g. using SQL Editor TOAD or SQL DEveloper the column is shown
16.04.2025 00:00:00,000000 instead of 16.04.2025 00:00:00.

Remark:
Requested format is important for importing into other applicatins.
Oracle connector has to be configured to your settings

Any idea?

Thanks for help!

BR,

Heinz

2

Hi Heinz,

The Column Data type of the particular column is Timestamp or similar in the Oracle Database, right?
For me it seems, that the issue is then not directly correlated with KNIME.

Andi

1 Like