I am using PostgreSQL which has two date columns with data type as "character varying". When I connect Talend and try to read the data. it gives me the below error: Exception in component tDBInput_1 (t1) org.postgresql.util.PSQLException: Bad value for type timestamp : 2006-03-24-09.45.00.000000. Even if I try to change the data type to string or use the available date patterns, it still shows the same error. Please let me know how to deal with this if I do not want to change the datatype at the DB level.
Can you please clarify in which Talend version/edition you are? Screenshots of your job setting will be preferred.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema