Global Sourcebook for International Data Management

                                         by Graham Rhind

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

_____


____

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
Afghanistan yyyy/mm/dd 14:32
Albania dd/mm/yyyy 14:32
Algeria dd/mm/yyyy 14:32
Andorra dd/mm/yyyy 14:32
Angola dd/mm/yyyy 14:32
Anguilla dd/mm/yyyy 14:32
Antigua and Barbuda dd/mm/yyyy 14:32
Argentina dd/mm/yyyy 14:32
Armenia dd.mm.yyyy 14:32
Aruba dd-mm-yyyy 14:32
Ascension Island dd/mm/yyyy 14:32
Australia dd.mm.yyyy
dd/mm/yyyy
14:32
Austria dd.mm.yyyy
yyyy-mm-dd
14.32
14:32
Azerbaijan dd.mm.yyyy 14:32
Bahamas dd/mm/yyyy 14:32
Bahrain dd/mm/yyyy 14:32
Bangladesh dd/mm/yyyy
dd-mm-yyyy
14:32
Barbados dd/mm/yyyy 14:32
Belarus dd.mm.yyyy
dd/mm/yyyy
14:32
Belgium dd/mm/yyyy 14:32
Belize dd/mm/yyyy 14:32
Benin dd.mm.yyyy
dd/mm/yyyy
dd-mm-yyyy
14:32
14h32
Bermuda dd/mm/yyyy 14:32
Bhutan yyyy-mm-dd 14:32
Bolivia dd/mm/yyyy 14:32
Bonaire dd-mm-yyyy 14:32
Bosnia-Hercegovina dd.mm.yyyy. 14:32
Botswana dd/mm/yyyy
yyyy-mm-dd
14:32
Brazil dd.mm.yyyy
dd/mm/yyyy
14:32
British Virgin Islands dd/mm/yyyy 14:32
Brunei Darussalam dd/mm/yyyy 14:32
Bulgaria dd.mm.yyyy 14:32
Burkina Faso dd/mm/yyyy
yyyy-mm-dd
14:32
Burundi dd/mm/yyyy 14:32
Cambodia dd/mm/yyyy 14:32
Cameroon dd/mm/yyyy
yyyy-mm-dd
14:32
Canada dd/mm/yyyy
mm.dd.yyyy
mm/dd/yyyy
mm-dd-yyyy
yyyy-mm-dd
14:32
Cape Verde dd/mm/yyyy 14:32
Cayman Islands dd/mm/yyyy 14:32
Central African Republic dd/mm/yyyy 14:32
Chad dd/mm/yyyy 14:32
Chile dd/mm/yyyy 14:32
China yyyy.mm.dd
yyyy/mm/dd
yyyy-mm-dd
Christmas Island dd.mm.yyyy
dd/mm/yyyy
14:32
Cocos (Keeling) Islands dd.mm.yyyy
dd/mm/yyyy
14:32
Colombia dd/mm/yyyy 14:32
Comoros dd/mm/yyyy 14:32
Congo (Democratic Republic of - Kinshasa) dd/mm/yyyy 14:32
Congo (Republic of the - Brazzaville) dd/mm/yyyy 14:32
Cook Islands dd/mm/yyyy 14:32
Costa Rica dd/mm/yyyy 14:32
Croatia dd.mm.yyyy. 14:32
Cuba dd/mm/yyyy 14:32
Curacao dd-mm-yyyy 14:32
Cyprus dd.mm.yyyy
dd/mm/yyyy
14:32
Czechia / Czech Republic dd.mm.yyyy 14:32
Denmark dd-mm-yyyy 14:32
Djibouti dd/mm/yyyy
yyyy-mm-dd
14:32
Dominica dd/mm/yyyy 14:32
Dominican Republic dd/mm/yyyy 14:32
East Timor dd/mm/yyyy 14:32
Ecuador dd/mm/yyyy 14:32
Egypt dd/mm/yyyy 14:32
El Salvador dd/mm/yyyy 14:32
Equatorial Guinea dd/mm/yyyy 14:32
Eritrea dd/mm/yyyy 14:32
Estonia dd.mm.yyyy
dd/mm/yyyy
14:32
Ethiopia dd/mm/yyyy
Faeroe Islands / Faroe Islands dd.mm.yyyy 14:32
Falkland Islands dd/mm/yyyy 14:32
Fiji dd/mm/yyyy 14:32
Finland dd.mm.yyyy 14.32
France dd.mm.yyyy
dd/mm/yyyy
dd-mm-yyyy
14:32
14h32
French Guiana dd.mm.yyyy
dd/mm/yyyy
dd-mm-yyyy
14:32
14h32
French Polynesia dd.mm.yyyy
dd/mm/yyyy
dd-mm-yyyy
14:32
14h32
Gabon dd/mm/yyyy 14:32
Gambia dd/mm/yyyy
yyyy-mm-dd
14:32
Georgia dd.mm.yyyy 14:32
Germany d.month yyyy
dd.mm.yyyy
14.32
14:32
Ghana dd/mm/yyyy
mm/dd/yyyy
yyyy/mm/dd
yyyy-mm-dd
14:32
Gibraltar dd/mm/yyyy 14:32
Greece dd/mm/yyyy 14:32
Greenland dd.mm.yyyy
yyyy.mm.dd
14.32
Grenada dd/mm/yyyy 14:32
Guadeloupe dd.mm.yyyy
dd/mm/yyyy
dd-mm-yyyy
14:32
14h32
Guam mm.dd.yyyy
mm/dd/yyyy
mm-dd-yyyy
Guatemala dd/mm/yyyy
yyyy-mm-dd
14:32
Guernsey dd/mm/yyyy 14:32
Guinea dd/mm/yyyy
yyyy-mm-dd
14:32
Guinea-Bissau dd/mm/yyyy
yyyy-mm-dd
14:32
Guyana dd/mm/yyyy 14:32
Haiti dd/mm/yyyy 14:32
14h32
Holy See dd mm yyyy
dd/mm/yyyy
14:32
Honduras dd/mm/yyyy 14:32
Hong Kong dd/mm/yyyy 14:32
Hungary yyyy.mm.dd. 14:32
Iceland dd.mm.yyyy
dd/mm/yyyy
14:32
India dd mm yyyy
dd/mm/yyyy
dd-mm-yyyy
yyyy mm dd
14.32
14:32
Indonesia dd/mm/yyyy 14:32
Iran yyyy/mm/dd 14:32
Iraq dd/mm/yyyy 14:32
Ireland dd mm yyyy
dd.mm.yyyy
dd/mm/yyyy
dd-mm-yyyy
14:32
Isle of Man dd mm yyyy
dd.mm.yyyy
dd/mm/yyyy
dd-mm-yyyy
14:32
Israel dd.mm.yyyy
dd/mm/yyyy
14:32
Italy dd/mm/yyyy 14:32
Ivory Coast dd.mm.yyyy
dd/mm/yyyy
dd-mm-yyyy
14:32
14h32
Jamaica dd/mm/yyyy 14:32
Japan yyyy.mm.dd
yyyy年mm月dd
14:32
Jersey dd/mm/yyyy 14:32
Jordan dd/mm/yyyy 14:32
Kazakhstan dd.mm.yyyy 14:32
Kenya dd/mm/yyyy 14:32
Kiribati dd/mm/yyyy 14:32
Kosovo dd.mm.yyyy 14:32
Kuwait dd/mm/yyyy 14:32
Kyrgyzstan dd.mm.yyyy 14:32
Laos dd/mm/yyyy 14:32
Latvia dd.mm.yyyy
dd/mm/yyyy
yyyy-mm-dd
14:32
Lebanon dd/mm/yyyy 14:32
Lesotho dd/mm/yyyy
yyyy-mm-dd
14:32
Liberia dd/mm/yyyy
yyyy-mm-dd
14:32
Libya dd/mm/yyyy 14:32
Liechtenstein dd.mm.yyyy 14:32
Lithuania yyyy-mm-dd 14:32
Luxembourg dd.mm.yy
dd/mm/yy
14:32
Macao dd/mm/yyyy
yyyy.mm.dd
yyyy/mm/dd
yyyy-mm-dd
14:32
Madagascar yyyy-mm-dd 14:32
Malawi dd/mm/yyyy
yyyy-mm-dd
14:32
Malaysia dd/mm/yyyy 14:32
Maldives dd-mm-yyyy 14:32
Mali dd/mm/yyyy 14:32
Malta dd/mm/yyyy 14:32
Marshall Islands mm.dd.yyyy
mm/dd/yyyy
mm-dd-yyyy
Martinique dd.mm.yyyy
dd/mm/yyyy
dd-mm-yyyy
14:32
14h32
Mauritania dd/mm/yyyy
yyyy-mm-dd
14:32
Mauritius dd/mm/yyyy 14:32
Mayotte dd.mm.yyyy
dd/mm/yyyy
dd-mm-yyyy
14:32
14h32
Mexico dd/mm/yyyy 14:32
Micronesia dd/mm/yyyy 14:32
Moldova dd.mm.yyyy 14:32
Monaco dd.mm.yyyy
dd/mm/yyyy
dd-mm-yyyy
14:32
14h32
Mongolia yyyy.mm.dd 14:32
Montenegro dd.mm.yyyy. 14:32
Montserrat dd/mm/yyyy 14:32
Morocco dd/mm/yyyy 14:32
Mozambique dd/mm/yyyy 14:32
Myanmar dd-mm-yyyy 14:32
Namibia dd/mm/yyyy
yyyy-mm-dd
14:32
Nauru dd/mm/yyyy 14:32
Nepal yyyy/mm/dd
yyyy-mm-dd
14:32
Netherlands dd-mm-yyyy 14:32
New Caledonia dd.mm.yyyy
dd/mm/yyyy
dd-mm-yyyy
14:32
14h32
New Zealand dd/mm/yyyy
dd-mm-yyyy
14:32
Nicaragua dd/mm/yyyy 14:32
Niger dd/mm/yyyy
yyyy-mm-dd
14:32
Nigeria dd/mm/yyyy
yyyy/mm/dd
yyyy-mm-dd
14:32
Niue dd/mm/yyyy 14:32
Norfolk Island dd.mm.yyyy
dd/mm/yyyy
14:32
North Korea yyyy.mm.dd 14:32
North Macedonia dd.mm.yyyy 14:32
Northern Mariana Islands mm.dd.yyyy
mm/dd/yyyy
mm-dd-yyyy
Norway dd.mm.yyyy
dd/mm/yyyy
14:32
Oman dd/mm/yyyy
yyyy-mm-dd
14:32
Pakistan dd/mm/yyyy 14:32
Palau dd/mm/yyyy 14:32
Panama mm/dd/yyyy 14:32
Papua New Guinea dd/mm/yyyy 14:32
Paraguay dd/mm/yyyy
yyyy-mm-dd
14:32
Peru dd/mm/yyyy 14:32
Philippines dd/mm/yyyy
mm/dd/yyyy
14:32
Pitcairn Islands dd/mm/yyyy 14:32
Poland dd.mm.yyyy
dd/mm/yyyy
yyyy-mm-dd
14:32
Portugal dd/mm/yyyy
dd-mm-yyyy
14:32
Puerto Rico dd/mm/yyyy 14:32
Qatar dd/mm/yyyy 14:32
Reunion dd.mm.yyyy
dd/mm/yyyy
dd-mm-yyyy
14:32
14h32
Romania dd.mm.yyyy
dd/mm/yyyy
14:32
Russia dd.mm.yyyy
dd/mm/yyyy
14:32
Rwanda dd/mm/yyyy
yyyy-mm-dd
14:32
Saba dd-mm-yyyy 14:32
Saint Helena dd/mm/yyyy 14:32
Saint Kitts and Nevis dd/mm/yyyy 14:32
Saint Lucia dd/mm/yyyy 14:32
Saint Pierre and Miquelon dd.mm.yyyy
dd/mm/yyyy
dd-mm-yyyy
14:32
14h32
Saint Vincent and the Grenadines dd/mm/yyyy 14:32
Saint-Barthelemy dd.mm.yyyy
dd/mm/yyyy
dd-mm-yyyy
14:32
14h32
Saint-Martin dd.mm.yyyy
dd/mm/yyyy
dd-mm-yyyy
14:32
14h32
Samoa dd/mm/yyyy 14:32
San Marino dd/mm/yyyy 14:32
Sao Tome and Principe dd/mm/yyyy 14:32
Saudi Arabia dd/mm/yyyy 14:32
Senegal dd/mm/yyyy
dd-mm-yyyy
yyyy-mm-dd
14:32
Serbia dd.mm.yyyy. 14:32
Seychelles dd/mm/yyyy 14:32
Sierra Leone dd/mm/yyyy
yyyy-mm-dd
14:32
Singapore dd/mm/yyyy
yyyy年m月d日
14:32
Sint Eustatius dd-mm-yyyy 14:32
Sint Maarten dd-mm-yyyy 14:32
Slovakia dd.mm.yyyy 14:32
Slovenia dd.mm.yyyy
dd/mm/yyyy
14:32
Solomon Islands dd/mm/yyyy 14:32
Somalia dd/mm/yyyy 14:32
South Africa mm/dd/yyyy
yyyy/mm/dd
yyyy-mm-dd
14:32
South Korea yyyy.mm.dd
yyyy년 mm월 dd일
14:32
South Sudan dd/mm/yyyy 14:32
Spain dd/mm/yyyy
yyyy.mm.dd
14:32
Sri Lanka dd/mm/yyyy
yyyy-mm-dd
14:32
Sudan dd/mm/yyyy 14:32
Suriname dd-mm-yyyy 14:32
Swaziland dd/mm/yyyy
yyyy-mm-dd
14:32
Sweden dd/mm yyyy
dd/mm/yy
dd/mm-yy
dd/mm-yyyy
yyyy-mm-dd
14:32
Switzerland dd.mm.yyyy 14,32
14.32
14:32
Syria dd/mm/yyyy 14:32
Taiwan yyyy.mm.dd
yyyy/mm/dd
yyyy-mm-dd
14:32
Tajikistan dd.mm.yyyy
dd/mm/yyyy
14:32
Tanzania dd/mm/yyyy 14:32
Thailand dd/mm/yyyy 14:32
Togo dd/mm/yyyy
mm/dd/yyyy
14:32
Tokelau dd/mm/yyyy 14:32
Tonga dd/mm/yyyy 14:32
Trinidad and Tobago dd/mm/yyyy 14:32
Tunisia dd/mm/yyyy 14:32
Turkey dd/mm/yyyy 14:32
Turkmenistan dd.mm.yyyy 14:32
Turks and Caicos Islands dd/mm/yyyy 14:32
Tuvalu dd/mm/yyyy 14:32
Uganda dd/mm/yyyy 14:32
Ukraine dd.mm.yyyy 14:32
United Arab Emirates dd/mm/yyyy 14:32
United Kingdom dd/mm/yyyy 14:32
United States of America mm.dd.yyyy
mm/dd/yyyy
mm-dd-yyyy
United States Virgin Islands mm.dd.yyyy
mm/dd/yyyy
mm-dd-yyyy
Uruguay dd/mm/yyyy 14:32
Uzbekistan dd.mm.yyyy
dd/mm/yyyy
14:32
Vanuatu dd/mm/yyyy 14:32
Venezuela dd/mm/yyyy 14:32
Vietnam dd/mm/yyyy 14:32
Wallis and Futuna dd.mm.yyyy
dd/mm/yyyy
dd-mm-yyyy
14:32
14h32
Western Sahara dd/mm/yyyy 14:32
Yemen dd/mm/yyyy 14:32
Zambia dd/mm/yyyy 14:32
Zimbabwe dd/mm/yyyy
yyyy-mm-dd
14:32


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 2022. Any information used should be acknowledged and referenced.