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
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.