Date Formats - 7.3

Talend Data Preparation User Guide

author
Talend Documentation Team
EnrichVersion
7.3
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
task
Data Quality and Preparation > Cleansing data
EnrichPlatform
Talend Data Preparation
Depending on the countries, dates may have different formats. Here are the elements that can help you change the date format or customize it.
Date format Description
EEEE Day of the week
MM Month of the year in a two-digit format
MMM Abbreviated month of the year
MMMM Month of the year
dd Day of the month
yy Year in two-digit format
yyyy Year in four-digit format
YYYY Week-based year
HH Hour of the day (0-23)
hh Clock hour in AM/PM (1-12) format
mm Minute
ss Second
SSS Fraction of a second
a AM/PM marker
Z UTC time offset