Hi,
I am having a similar issue writing datetime columns to PostgreSql. I am using Knime 3.7.2, and trying to write data from a csv to the database.
The datetime columns are strings in the format yyyy-mm-dd HH:mm:ss and I have converted to datetime using the String to Date&time node. It writes to the db fine, but when I re-import the data in Knime or try using it in Tableau, its a string.
I’ve also tried adding milliseconds as suggested in this post MySQL Writing DateTime Bug, but then String to Date&Time won’t work on this.
I’ve also tried changing the SQL types in the Database Writer node, but this also fails.
The csv file was originally generated through another knime workflow.
Any help much appreciated