Date Formats
Table 1-2 shows some of the date formats used around the world. Notice that even within a country, there can be variations.
Table 1-2 International Date Formats|
Locale |
Convention |
Example |
|---|---|---|
|
Canadian (English and French) |
yyyy-mm-dd |
1998-08-13 |
|
Danish |
yyyy-mm-dd |
1999-08-24 |
|
Finnish |
dd.mm.yyyy |
13.08.1998 |
|
French |
dd/mm/yyyy |
13/08/1999 |
|
German |
yyyy-mm-dd |
1999-09-18 |
|
Italian |
dd.mm.yy |
13.08.98 |
|
Norwegian |
dd.mm.yy |
13.08.98 |
|
Spanish |
dd-mm-yy |
13-08-98 |
|
Swedish |
yyyy-mm-dd |
1998-08-13 |
|
GB-English |
dd/mm/yy |
13/08/98 |
|
US-English |
mm-dd-yy |
08-13-98 |
|
Thai |
dd/mm/yyyy |
10/12/2009 |
- © 2010, Oracle Corporation and/or its affiliates