topic SQL server date datatype to Postgres date datatype conversion in Talend Studio

SQL server date datatype to Postgres date datatype conversion

Anonymous — Tue, 04 Sep 2018 08:26:46 GMT

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

Re: SQL server date datatype to Postgres date datatype conversion

fdenis — Tue, 04 Sep 2018 11:12:05 GMT

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