Reading and writing dates with database writer issue

KNIME Analytics Platform
1

Hi,

 

I found that when reading dates from a SQL database and then writing them back to a database with the same database connector time zone settings the writer adds time for DST (Daylight Savings Time). How can I simply just write the date to a SQL database without the writer making any changes to the actual date? I simply want to pass through the date and it needs to write what is passed.

2

I've narrowed it down to the Database Writer that automatically adjusts the time depending on DST when writing datetime columns to a SQL database. All I need is for the Database Writer to write the datetime column as is and not to do anything to the actual date.