SQL server date datatype to Postgres date datatype conversion
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
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 .
