Schemas in Talend Open Studio can automatically turn text strings into date objects. Once Talend recognizes a field as a date, that date can be made available to other components without having to worry about format.
The following screenshot is a text file with fields of various date formats.
|Input File with Different Date Formats|
"MMMM dd, yyyy"
MMMM uses the full month, like "December". MMM is for an abbreviated month, "Dec". MM is used for numeric values ("12").
This is a simple tFileInputDelimited to tLogRow Job.
|Job Showing Date Conversions|
The following schema identifies each field as a date and provides a date pattern. It's for the tFileInputDelimited.
|Schema with Different Date Format|
|Schema Applying a Common Date Format|
|Running a Job with a Common Date Format|