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
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.