Writing incorrect datetime in Oracle

database
#1

Hi,

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?

0 Likes
#2

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

0 Likes