Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-09-06 05:15 AM

Error in Talend Open Studio : Exception in component tDBInput_1 (t1) org.postgresql.util.PSQLException: Bad value for type timestamp : 2006-03-24-09.45.00.000000

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.

 

Thanks!!

 

Labels (2)
Labels
651 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2018-09-17 05:59 AM
Author

Hello,

Can you please clarify in which Talend version/edition you are? Screenshots of your job setting will be preferred.

Best regards

Sabrina

651 Views
0 Likes