Changing the date format

Talend Data Preparation Quick Examples

author
Talend Documentation Team
EnrichVersion
6.5
2.3
EnrichProdName
Talend Data Services Platform
Talend Big Data
Talend Real-Time Big Data Platform
Talend Data Integration
Talend Data Fabric
Talend MDM Platform
Talend Big Data Platform
Talend ESB
Talend Data Management Platform
task
Data Quality and Preparation > Cleansing data
EnrichPlatform
Talend Data Preparation

As the date formats used across the world are not the same, you may need to change the format used in a column containing dates.

You will change the date format that is used in this dataset, from the American format, to the French format.

Procedure

  1. Select the Entry_Date column.
  2. In the functions panel, on the right side of the screen, type Change Date Format and click the result to open the options for the associated function.
  3. Configure the function as follows.

    The French format that you want to use, dd/MM/yyyy, is not available by defaut so you have to enter it as a custom value in the Your Format field.

    For example, this will change 12/25/2015 to 25/12/2015.

  4. Point your mouse over the Submit button to preview the changes, and click it to apply the function.

    You have the possibility to output the result of this function in a new column by selecting the Create new column check box.

Results

The date format is changed in the selected column.