List of date and date/time formats - 2.3

Talend Data Preparation User Guide

author
Talend Documentation Team
EnrichVersion
6.5
2.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

Date and time are formatted according to the different conventions all around the world. Locale-specific date and date/time formats are specified by date and time pattern strings. The following tables provide information on the patterns which are recognized as date or date/time data in Talend Data Preparation.

According to the locale of your Java installation, the validation results may be different when using patterns which have a weekday and a month name. Talend Data Preparation first validates dates and times using the en_US locale and then, using the default locale of the Java installation of the server.

For example, if the Java Virtual Machine locale is set to French, "22. March 1999” and "22. mars 1999” will be valid dates but not "22. März 1999”, even though d. MMMM yyyy is originally a German pattern.

ISO 8601 patterns

Date and time patterns

Example

yyyyMMddZ

19990322+0100

yyyyMMdd

19990322

yyyy-MM-dd G

1999-03-22 AD

yyyy-MM-ddXXX

1999-03-22+01:00

yyyy-MM-dd'T'HH:mm:ss.SSS'['VV']'

1999-03-22T05:06:07.000[Europe/Paris]

yyyy-MM-dd'T'HH:mm:ss.SSS

1999-03-22T05:06:07.000

yyyy-MM-dd'T'HH:mm:ss

1999-03-22T05:06:07

yyyy-MM-dd'T'HH:mm:ss.SSS'Z'

1999-03-22T05:06:07.000Z

yyyy-MM-dd'T'HH:mm:ss.SSSXXX

1999-03-22T05:06:07.000+01:00

yyyy-MM-dd'T'HH:mm:ssXXX

1999-03-22T05:06:07+01:00

yyyy-DDDXXX

1999-081+01:00

YYYY'W'wc

1999W132

YYYY-'W'w-c

1999-W13-2

yyyy-MM-dd'T'HH:mm:ss.SSSXXX'['VV']'

1999-03-22T05:06:07.000+01:00[Europe/Paris]

yyyy-MM-dd'T'HH:mm:ssXXX'['VV']'

1999-03-22T05:06:07+01:00[Europe/Paris]

Locale be: Belarussian

Date and time patterns

Example

d.M.yy

22.3.99

d.M.yy H.mm

22.3.99 5.06

d.M.yyyy H.mm.ss

22.3.1999 5.06.07

Locale cs: Czech

Date and time patterns

Example

d.M.yyyy H:mm:ss

22.3.1999 5:06:07

Locale da: Danish

Date and time patterns

Example

dd-MM-yy

22-03-99

dd-MM-yy HH:mm

22-03-99 05:06

dd-MM-yyyy HH:mm:ss

22-03-1999 05:06:07

Locale de_DE: German, Germany

Date and time patterns

Example

dd.MM.yy

22.03.99

d. MMMM yyyy

22. März 1999

EEEE, d. MMMM yyyy

Montag, 22. März 1999

dd.MM.yyyy

22.03.1999

dd.MM.yy HH:mm

22.03.99 05:06

d. MMMM yyyy HH:mm:ss z

22. März 1999 05:06:07 MEZ

dd.MM.yyyy HH:mm:ss

22.03.1999 05:06:07

dd.MM.yy HH:mm:ss

22.03.99 05:06:07

dd.MM.yyyy HH:mm

22.03.1999 05:06

EEEE, d. MMMM yyyy HH:mm' Uhr 'z

Montag, 22. März 1999 05:06 Uhr MEZ

Locale en_CA: English, Canada

Date and time patterns

Example

d-MMM-yyyy

22-Mar-1999

dd/MM/yy h:mm a

22/03/99 5:06 AM

EEEE, MMMM d, yyyy h:mm:ss 'o''clock' a z

Monday, March 22, 1999 5:06:07 o'clock AM CET

d-MMM-yyyy h:mm:ss a

22-Mar-1999 5:06:07 AM

Locale en_GB: English, United Kingdom

Date and time patterns

Example

dd MMMM yyyy

22 March 1999

EEEE, d MMMM yyyy

Monday, 22 March 1999

dd-MMM-yyyy

22-Mar-1999

dd MMMM yyyy HH:mm:ss z

22 March 1999 05:06:07 CET

EEEE, d MMMM yyyy HH:mm:ss 'o''clock' z

Monday, 22 March 1999 05:06:07 o'clock CET

dd-MMM-yyyy HH:mm:ss

22-Mar-1999 05:06:07

dd-MMM-yy hh.mm.ss.nnnnnnnnn a

22-Mar-99 05.06.07.000000888 AM

Locale en_US : English, United States

Date and time patterns

Example

M/d/yy

3/22/99

MM/dd/yy

03/11/22

MM-dd-yy

03-22-99

M-d-yy

3-22-99

MMM d, yyyy

Mar 22, 1999

MMMM d, yyyy

March 22, 1999

EEEE, MMMM d, yyyy

Monday, March 22, 1999

MMM d yyyy

Mar 22 1999

MMMM d yyyy

March 22 1999

MM-dd-yyyy

03-22-1999

M-d-yyyy

3-22-1999

yyyy-MM-ddXXX

1999-03-22+01:00

dd/MM/yyyy

22/03/1999

d/M/yyyy

22/3/1999

MM/dd/yyyy

03/22/1999

M/d/yyyy

3/22/1999

yyyy/M/d

1999/3/22

M/d/yy h:mm a

3/22/99 5:06 AM

MM/dd/yy h:mm a

03/22/99 5:06 AM

MM-dd-yy h:mm a

03-22-99 5:06 AM

M-d-yy h:mm a

3-22-99 5:06 AM

MMM d, yyyy h:mm:ss a

Mar 22, 1999 5:06:07 AM

EEEE, MMMM d, yyyy h:mm:ss a z

Monday, March 22, 1999 5:06:07 AM CET

EEE MMM dd HH:mm:ss z yyyy

Mon Mar 22 05:06:07 CET 1999

EEE, d MMM yyyy HH:mm:ss Z

Mon, 22 Mar 1999 05:06:07 +0100

d MMM yyyy HH:mm:ss Z

22 Mar 1999 05:06:07 +0100

MM-dd-yyyy h:mm:ss a

03-22-1999 5:06:07 AM

M-d-yyyy h:mm:ss a

3-22-1999 5:06:07 AM

yyyy-MM-dd h:mm:ss a

1999-03-22 5:06:07 AM

yyyy-M-d h:mm:ss a

1999-3-22 5:06:07 AM

yyyy-MM-dd HH:mm:ss.S

1999-03-22 05:06:07.0

dd/MM/yyyy h:mm:ss a

22/03/1999 5:06:07 AM

d/M/yyyy h:mm:ss a

22/3/1999 5:06:07 AM

MM/dd/yyyy h:mm:ss a

03/22/1999 5:06:07 AM

M/d/yyyy h:mm:ss a

3/22/1999 5:06:07 AM

MM/dd/yy h:mm:ss a

03/22/99 5:06:07 AM

MM/dd/yy H:mm:ss

03/22/99 5:06:07

M/d/yy H:mm:ss

3/22/99 5:06:07

dd/MM/yyyy h:mm a

22/03/1999 5:06 AM

d/M/yyyy h:mm a

22/3/1999 5:06 AM

MM/dd/yyyy h:mm a

03/22/1999 5:06 AM

M/d/yyyy h:mm a

3/22/1999 5:06 AM

MM-dd-yy h:mm:ss a

03-22-99 5:06:07 AM

M-d-yy h:mm:ss a

3-22-99 5:06:07 AM

MM-dd-yyyy h:mm a

03-22-1999 5:06 AM

M-d-yyyy h:mm a

3-22-1999 5:06 AM

yyyy-MM-dd h:mm a

1999-03-22 5:06 AM

yyyy-M-d h:mm a

1999-3-22 5:06 AM

MMM.dd.yyyy

Mar.22.1999

d/MMM/yyyy H:mm:ss Z

22/Mar/1999 5:06:07 +0100

dd/MMM/yy h:mm a

22/Mar/99 5:06 AM

Locale es: Spanish

Date and time patterns

Example

d/MM/yy

22/03/99

d/MM/yy H:mm

22/03/99 5:06

d.M.yy H:mm

22.3.99 5:06

Locale et: Estonian

Date and time patterns

Example

d.MM.yy

22.03.99

d.MM.yyyy

22.03.1999

d.MM.yy H:mm

22.03.99 5:06

d.MM.yyyy H:mm:ss

22.03.1999 5:06:07

Locale fi: Finnish

Date and time patterns

Example

d.M.yyyy

22.3.1999

d.M.yyyy H:mm

22.3.1999 5:06

Locale fr_CA: French, Canada

Date and time patterns

Example

yy-MM-dd

99-03-22

yyyy-MM-dd

1999-03-22

d MMMM yyyy HH:mm:ss z

22 mars 1999 05:06:07 CET

MMMM d, yyyy h:mm:ss z a

March 22, 1999 5:06:07 CET AM

yyyy-MM-dd HH:mm:ss

1999-03-22 05:06:07

EEEE d MMMM yyyy H' h 'mm z

lundi 22 mars 1999 5 h 06 CET

Locale fr_FR: French, France

Date and time patterns

Example

dd/MM/yy

22/03/99

d MMM yyyy

22 mars 1999

d MMMM yyyy

22 mars 1999

EEEE d MMMM yyyy

lundi 22 mars 1999

dd/MM/yy HH:mm

22/03/99 05:06

MM/dd/yy HH:mm

03/22/99 05:06

M/d/yy HH:mm

3/22/99 05:06

MM-dd-yy HH:mm

03-22-99 05:06

M-d-yy HH:mm

3-22-99 05:06

d MMM yyyy HH:mm:ss

22 mars 1999 05:06:07

d MMMM yyyy HH:mm:ss z

22 mars 1999 05:06:07 CET

MM-dd-yyyy HH:mm:ss

03-22-1999 05:06:07

M-d-yyyy HH:mm:ss

3-22-1999 05:06:07

yyyy-M-d HH:mm:ss

1999-3-22 05:06:07

dd/MM/yyyy HH:mm:ss

22/03/1999 05:06:07

d/M/yyyy HH:mm:ss

22/3/1999 05:06:07

MM/dd/yyyy HH:mm:ss

03/22/1999 05:06:07

M/d/yyyy HH:mm:ss

3/22/1999 05:06:07

EEEE d MMMM yyyy HH' h 'mm z

lundi 22 mars 1999 05 h 06 CET

dd/MM/yy HH:mm:ss

22/03/99 05:06:07

MM/dd/yy HH:mm:ss

03/22/99 05:06:07

M/d/yy HH:mm:ss

3/22/99 05:06:07

dd/MM/yyyy HH:mm

22/03/1999 05:06

d/M/yyyy HH:mm

22/3/1999 05:06

MM/dd/yyyy HH:mm

03/22/1999 05:06

M/d/yyyy HH:mm

3/22/1999 05:06

MM-dd-yy HH:mm:ss

03-22-99 05:06:07

M-d-yy HH:mm:ss

3-22-99 05:06:07

MM-dd-yyyy HH:mm

03-22-1999 05:06

M-d-yyyy HH:mm

3-22-1999 05:06

yyyy-M-d HH:mm

1999-3-22 05:06

Locale ga: Irish

Date and time patterns

Example

yy/MM/dd HH:mm

99/03/22 05:06

Locale hr: Croatian

Date and time patterns

Example

yyyy.MM.dd

1999.03.22

yyyy.MM.dd HH:mm:ss

1999.03.22 05:06:07

yyyy.MM.dd HH:mm

1999.03.22 05:06

Locale hu: Hungarian

Date and time patterns

Example

yyyy.MM.dd.

1999.03.22.

yyyy.MM.dd. H:mm:ss

1999.03.22. 5:06:07

yyyy.MM.dd. H:mm

1999.03.22. 5:06

Locale is: Icelandic

Date and time patterns

Example

d.M.yyyy HH:mm:ss

22.3.1999 05:06:07

d.M.yyyy HH:mm

22.3.1999 05:06

Locale it_IT: Italian, Italy

Date and time patterns

Example

d-MMM-yyyy

22-mar-1999

dd/MM/yy H.mm

22/03/99 5.06

yy-MM-dd HH:mm

99-03-22 05:06

d-MMM-yyyy H.mm.ss

22-mar-1999 5.06.07

d MMMM yyyy H.mm.ss z

22 marzo 1999 5.06.07 CET

EEEE d MMMM yyyy H.mm.ss z

lunedì 22 marzo 1999 5.06.07 CET

Locale iw: Hebrew

Date and time patterns

Example

HH:mm dd/MM/yy

05:06 22/03/99

HH:mm:ss dd/MM/yyyy

05:06:07 22/03/1999

Locale ja_JP: Japanese, Japan

Date and time patterns

Example

yy/MM/dd

99/03/22

yyyy/MM/dd

1999/03/22

yy/MM/dd H:mm

99/03/22 5:06

MM/dd/yy H:mm

03/22/99 5:06

M/d/yy H:mm

3/22/99 5:06

MM-dd-yy H:mm

03-22-99 5:06

M-d-yy H:mm

3-22-99 5:06 AM

MM-dd-yyyy H:mm:ss

03-22-1999 5:06:07

M-d-yyyy H:mm:ss

3-22-1999 5:06:07

yyyy-MM-dd H:mm:ss

1999-03-22 5:06:07

yy/MM/dd H:mm:ss

99/03/22 5:06:07

M/d/yy h:mm:ss a

3/22/99 5:06:07 AM

yyyy/MM/dd H:mm

1999/03/22 5:06

dd/MM/yyyy H:mm

22/03/1999 5:06

d/M/yyyy H:mm

22/3/1999 5:06

MM/dd/yyyy H:mm

03/22/1999 5:06

M/d/yyyy H:mm

3/22/1999 5:06

MM-dd-yy H:mm:ss

03-22-99 5:06:07

M-d-yy H:mm:ss

3-22-99 5:06:07

MM-dd-yyyy H:mm

03-22-1999 5:06

M-d-yyyy H:mm

3-22-1999 5:06

yyyy-MM-dd H:mm

1999-03-22 5:06

yyyy-M-d H:mm

1999-3-22 5:06

Locale ko: Korean

Date and time patterns

Example

yy. M. d

99. 3. 22

yyyy. M. d

1999. 3. 22

Locale lt: Lithuanian

Date and time patterns

Example

yy.M.d

99.3.22

yy.M.d HH.mm

99.3.22 05.06

yyyy-MM-dd HH.mm.ss

1999-03-22 05.06.07

Locale lv: Latvian

Date and time patterns

Example

yy.d.M

99.22.3

yyyy.d.M

1999.22.3

yy.d.M HH:mm

99.22.3 05:06

yyyy.d.M HH:mm:ss

1999.22.3 05:06:07

Locale mk: Macedonian

Date and time patterns

Example

d.M.yy HH:mm

22.3.99 05:06

d.M.yyyy HH:mm:

22.3.1999 05:06:

Locale nl: Dutch

Date and time patterns

Example

d-M-yy

22-3-99

d-M-yy H:mm

22-3-99 5:06

Locale pt: Portuguese

Date and time patterns

Example

dd-MM-yyyy

22-03-1999

dd-MM-yyyy H:mm

22-03-1999 5:06

Locale ru: Russian

Date and time patterns

Example

dd.MM.yy H:mm

22.03.99 5:06

dd.MM.yyyy H:mm:ss

22.03.1999 5:06:07

Locale sq: Albanian

Date and time patterns

Example

yyyy-MM-dd h:mm:ss.a

1999-03-22 5:06:07.PD

yy-MM-dd h.mm.a

99-03-22 5.06.PD

yyyy-MM-dd h.mm.ss.a z

1999-03-22 5.06.07.PD CET

Locale sr: Serbian

Date and time patterns

Example

d.M.yy.

22.3.99.

dd.MM.yyyy.

22.03.1999.

d.M.yy. HH.mm

22.3.99. 05.06

dd.MM.yyyy. HH.mm.ss

22.03.1999. 05.06.07

dd.MM.yyyy. HH.mm.ss z

22.03.1999. 05.06.07 CET

Locale vi: Vietnamese

Date and time patterns

Example

HH:mm:ss dd-MM-yyyy

05:06:07 22-03-1999

HH:mm dd/MM/yyyy

05:06 22/03/1999

Locale zh_CN: Chinese (Simplified), China

Date and time patterns

Example

yy-M-d

99-3-22

yyyy-M-d

1999-3-22

yyyy'年'M'月'd'日'

1999年3月22日

yyyy'年'M'月'd'日' EEEE

1999年3月22日 星期一

yy-M-d ah:mm

99-3-22 上午5:06

yyyy-M-d H:mm:ss

1999-3-22 5:06:07

yyyy'年'M'月'd'日' ahh'时'mm'分'ss'秒'

1999年3月22日 上午05时06分07秒

yyyy'年'M'月'd'日' H'時'mm'分'ss'秒' z

1999年3月22日 5時06分07秒 CET

yyyy'年'M'月'd'日' EEEE ahh'时'mm'分'ss'秒' z

1999年3月22日 星期一 上午05时06分07秒 CET