Global Sourcebook for International Data Management

                                         by Graham Rhind

Help us to keep this resource free!
Support/Advertise/Donate

_____


____

This resource is also available as a PDF file

Summary: Date/Time format

Global Sourcebook | Index | Properties

Tips for practical management of date information External

Tips for practical management of time information External

Date and time formats differ between and within countries and cultures.

ISO 8601 specifies numeric representations of date and time. The date standard notation is:

   YYYY-MM-DD

where YYYY is the year in the usual Gregorian calendar, MM is the month of the year between 01 (January) and 12 (December), and DD is the day of the month between 01 and 31.

The time standard notation is:

   hh:mm:ss

where hh is the number of complete hours that have passed since midnight (00-24), mm is the number of complete minutes that have passed since the start of the hour (00-59), and ss is the number of complete seconds since the start of the minute (00-60). If the hour value is 24, then the minute and second values must be zero.

Date format

image Note: this map comes from an external source and is not correct in all details

Time format

Overview

Date format Time format
Albania dd/mm/yyyy
Algeria dd/mm/yyyy
Argentina dd/mm/yyyy
Armenia dd.mm.yyyy
Australia dd.mm.yyyy
dd/mm/yyyy
Austria dd.mm.yyyy
yyyy-mm-dd
14.32
14:32
Azerbaijan dd.mm.yyyy
Bangladesh dd/mm/yyyy
dd-mm-yyyy
Barbados dd/mm/yyyy
Belarus dd.mm.yyyy
dd/mm/yyyy
Belgium dd/mm/yyyy
Belize dd/mm/yyyy
Bolivia dd/mm/yyyy
Brazil dd.mm.yyyy
dd/mm/yyyy
Bulgaria dd.mm.yyyy
Canada dd/mm/yyyy
mm.dd.yyyy
mm/dd/yyyy
mm-dd-yyyy
yyyy-mm-dd
Chile dd/mm/yyyy
China yyyy.mm.dd
yyyy/mm/dd
yyyy-mm-dd
Colombia dd/mm/yyyy
Croatia dd.mm.yyyy. 14:32
Cyprus dd/mm/yyyy
Czechia / Czech Republic dd.mm.yyyy
Denmark dd-mm-yyyy
Dominica dd/mm/yyyy
Dominican Republic dd/mm/yyyy
Ecuador dd/mm/yyyy
El Salvador dd/mm/yyyy
Estonia dd.mm.yyyy
dd/mm/yyyy
Finland dd.mm.yyyy
France dd.mm.yyyy
dd/mm/yyyy
dd-mm-yyyy
14h32
Georgia dd.mm.yyyy
Germany d.month yyyy
dd.mm.yyyy
14.32
14:32
Greece dd/mm/yyyy
Greenland dd.mm.yyyy
Grenada dd/mm/yyyy
Guyana dd/mm/yyyy
Hong Kong dd/mm/yyyy
Hungary yyyy.mm.dd.
Iceland dd.mm.yyyy
dd/mm/yyyy
India dd mm yyyy
dd/mm/yyyy
dd-mm-yyyy
yyyy mm dd
Indonesia dd/mm/yyyy
Iraq dd/mm/yyyy
Ireland dd mm yyyy
dd.mm.yyyy
dd/mm/yyyy
dd-mm-yyyy
Israel dd/mm/yyyy
Italy dd/mm/yyyy
Jamaica dd/mm/yyyy
Japan yyyy.mm.dd
yyyy年mm月dd
Kazakhstan dd.mm.yyyy
Kenya dd/mm/yyyy
Kyrgyzstan dd.mm.yyyy
Latvia dd.mm.yyyy
dd/mm/yyyy
yyyy-mm-dd
Lithuania yyyy-mm-dd
Macao dd/mm/yyyy
yyyy.mm.dd
yyyy/mm/dd
yyyy-mm-dd
Malaysia dd/mm/yyyy
Mexico dd/mm/yyyy
Micronesia mm/dd/yyyy
Montenegro dd.mm.yyyy.
Nepal yyyy-mm-dd
Netherlands dd-mm-yyyy
New Zealand dd/mm/yyyy
Norway dd.mm.yyyy
dd/mm yyyy
Pakistan dd/mm/yyyy
Palau mm/dd/yyyy
Paraguay dd/mm/yyyy
Peru dd/mm/yyyy
Philippines dd/mm/yyyy
mm/dd/yyyy
Poland dd.mm.yyyy
dd/mm/yyyy
yyyy-mm-dd
Portugal dd/mm/yyyy
dd-mm-yyyy
Puerto Rico dd/mm/yyyy
Romania dd.mm.yyyy
dd/mm/yyyy
Russia dd.mm.yyyy
dd/mm/yyyy
Saint Kitts and Nevis dd/mm/yyyy
Saint Lucia dd/mm/yyyy
Saint Vincent and the Grenadines dd/mm/yyyy
Saudi Arabia dd/mm/yyyy
Serbia dd.mm.yyyy.
Singapore dd/mm/yyyy
yyyy年m月d日
Slovakia dd.mm.yyyy
Slovenia dd.mm.yyyy
dd/mm/yyyy
South Africa mm/dd/yyyy
yyyy-mm-dd
South Korea yyyy.mm.dd
yyyy년 mm월 dd일
Spain dd/mm/yyyy
yyyy.mm.dd
Sweden dd/mm yyyy
dd/mm/yy
dd/mm-yy
dd/mm-yyyy
yyyy-mm-dd
Switzerland dd.mm.yyyy 14,32
14.32
14:32
Taiwan yyyy.mm.dd
yyyy/mm/dd
yyyy-mm-dd
Tajikistan dd.mm.yyyy
Thailand dd/mm/yyyy
Trinidad and Tobago dd/mm/yyyy
Turkey dd/mm/yyyy
Turkmenistan dd.mm.yyyy
Ukraine dd.mm.yyyy
United Kingdom dd/mm/yyyy
United States of America mm.dd.yyyy
mm/dd/yyyy
mm-dd-yyyy
Uruguay dd/mm/yyyy
Uzbekistan dd.mm.yyyy
dd/mm yyyy
Venezuela dd/mm/yyyy
Vietnam dd/mm/yyyy


Every effort is made to keep this resource updated. If you find any errors, or have any questions or requests, please don't hesitate to contact the author.

All information copyright Graham Rhind 2017. Any information used should be acknowledged and referenced.