My work around solution:
1. Change schema type from DATE to String in the tDBInput component
2. CAST column to VARCHAR in SQL Query:
CAST (column_name as CHAR(32)) as column_name
Join us at the Community Lounge.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Take a look at the Talend Studio improvements for API Services
Take a look at some Data Integration success stories