SQL server date datatype to Postgres date datatype conversion

[Anonymous]

I am inserting SQL server table data to Postgres table.date column example in SQL server: "2019-09-03 00:00:000000 +05:30".Should I directly map to Postgres table then which datatype should I select in postgres.should I use tmap and apply some logic for date conversion. I am getting error as "call getNextException to see the cause".So I am assuming it's due to date datatype conversion error.I am using SQL server 2008,Talend 6.2 and Postgres 10

[fdenis]

is there text before "call getNext..."
date is every time a trouble when migrating Data.
Im use to convert Date to String into select statement.
in sql server I use 112 126 127 format to have the right data.
and use a to_date function to load.

be careful each driver can have it's own language so your editor and talend may have 2 distinct lanuages.
Talend use Java so if you dont set it's java default languages.
so force date to string be careful to server time zone .


good luck