Writing incorrect datetime in Oracle


I use KNIME 3.7.2 and “oracle.jdbc.OracleDriver” connection with time zone correction set as “Use Local timezone”

When I use the Database Connection Table Writer, the written date in the Database are one day. In the table is ‘2019-05-15’ and in Database I get ‘2019-05-14’.

Do you know this problem?

Is the DB configured to use a different time zone than your desktop machine?

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.