Skip to content

Instantly share code, notes, and snippets.

@avelzo

avelzo/countries_date_format.csv

Last active March 31, 2023 12:12
Show Gist options
  • Save avelzo/3e7288ec493b04a0c775621dacfa14c7 to your computer and use it in GitHub Desktop.
Save avelzo/3e7288ec493b04a0c775621dacfa14c7 to your computer and use it in GitHub Desktop.
Download ZIP
Countries Date Formats
Raw
countries_date_format.csv
ISO3 ISO2 country ISO3_lang ISO2_lang language date_format
ALB AL Albania sqi sq Albanian yyyy-mm-dd
ARE AE United Arab Emirates ara ar Arabic dd/mm/yyyy
ARM AM Armenia arm hy Armenian yyyy-mm-dd
ARG AR Argentina spa es Spanish dd/mm/yyyy
AUS AU Australia eng en English dd-mm-yyyy
AUT AT Austria deu de German dd/mm/yyyy
AZE AZ Azerbaijan aze az Azerbaijani yyyy-mm-dd
BGD BD Bangladesh ben bn Bengali dd/mm/yyyy
BEL BE Belgium fra fr French dd/mm/yyyy
BEL BE Belgium nld nl Dutch dd/mm/yyyy
BGR BG Bulgaria bul bg Bulgarian dd.mm.yyyy
BHR BH Bahrain ara ar Arabic dd/MM/yyyy
BIH BA Bosnia and Herzegovina srp sr Serbian yyyy-mm-dd
BLR BY Belarus bel be Belarusian yyyy-mm-dd
BOL BO Bolivia spa es Spanish dd-MM-yyyy
BRA BR Brazil por pt Portuguese dd/MM/yyyy
CAN CA Canada fra fr French yyyy-MM-dd
CAN CA Canada eng en English dd/MM/yyyy
CHE CH Switzerland deu de German dd/mm/yyyy
CHE CH Switzerland fra fr French dd/mm/yyyy
CHE CH Switzerland ita it Italian dd/mm/yyyy
CHL CL Chile spa es Spanish dd-MM-yyyy
CHN CN China zho zh Chinese mm/dd/yyyy
COL CO Colombia spa es Spanish dd/MM/yyyy
CRI CR Costa Rica spa es Spanish dd/MM/yyyy
CYP CY Cyprus ell el Greek dd/MM/yyyy
CZE CZ Czech Republic ces cs Czech yyyy-mm-dd
DEU DE Germany deu de German dd.MM.yyyy
DNK DK Denmark dan da Danish dd-MM-yyyy
DOM DO Dominican Republic spa es Spanish MM/dd/yyyy
DZA DZ Algeria ara ar Arabic dd/MM/yyyy
ECU EC Ecuador spa es Spanish dd/MM/yyyy
EGY EG Egypt ara ar Arabic dd/MM/yyyy
ESP ES Spain spa es Spanish dd/MM/yyyy
ESP ES Spain cat ca Catalan dd/MM/yyyy
EST EE Estonia est et Estonian dd-mm-yyyy
ETH ET Ethiopia amh am Amharic dd/mm/yyyy
FIN FI Finland fin fi Finnish dd/mm/yyyy
FRA FR France fra fr French dd/MM/yyyy
GBR GB United Kingdom eng en English dd/MM/yyyy
GRC GR Greece ell el Greek dd/MM/yyyy
GTM GT Guatemala spa es Spanish dd/MM/yyyy
HKG HK Hong Kong zho zh Chinese yyyy-mm-dd
HND HN Honduras spa es Spanish MM-dd-yyyy
HRV HR Croatia hrv hr Croatian yyyy-mm-dd
HUN HU Hungary hun hu Hungarian yyyy-mm-dd
IDN ID Indonesia ind in Indonesian dd/MM/yyyy
IND IN India hin hi Hindi dd/mm/yyyy
IND IN India eng en English dd/mm/yyyy
IRL IE Ireland gle ga Irish dd/MM/yyyy
IRL IE Ireland eng en English dd/MM/yyyy
IRQ IQ Iraq ara ar Arabic dd/MM/yyyy
ISL IS Iceland isl is Icelandic dd-mm-yyyy
ISR IL Israel heb iw Hebrew dd/MM/yyyy
ITA IT Italy ita it Italian dd/MM/yyyy
JOR JO Jordan ara ar Arabic dd/MM/yyyy
JPN JP Japan jpn ja Japanese mm/dd/yyyy
KAZ KZ Kazakhstan kaz kk Kazakh dd/mm/yyyy
KEN KE Kenya eng en English dd/mm/yyyy
KHM KH Cambodia khm km Central khmer dd/mm/yyyy
KOR KR South Korea kor ko Korean mm/dd/yyyy
KWT KW Kuwait ara ar Arabic dd/MM/yyyy
LBN LB Lebanon ara ar Arabic dd/MM/yyyy
LBY LY Libya ara ar Arabic dd/MM/yyyy
LKA LK Sri Lanka sin si Sinhala dd-mm-yyyy
LTU LT Lithuania lit lt Lithuanian yyyy.mm.dd
LUX LU Luxembourg fra fr French dd/MM/yyyy
LUX LU Luxembourg deu de German dd.MM.yyyy
LVA LV Latvia lav lv Latvian yyyy.dd.MM
MAR MA Morocco ara ar Arabic dd/MM/yyyy
MEX MX Mexico spa es Spanish dd/MM/yyyy
MKD MK Macedonia mkd mk Macedonian dd.mm.yyyy
MLT MT Malta eng en English dd/MM/yyyy
MLT MT Malta mlt mt Maltese dd/MM/yyyy
MNE ME Montenegro srp sr Serbian yyyy-mm-dd
MYS MY Malaysia msa ms Malay dd/MM/yyyy
NGA NG Nigeria eng en English dd/mm/yyyy
NIC NI Nicaragua spa es Spanish MM-dd-yyyy
NLD NL Netherlands nld nl Dutch dd-mm-yyyy
NOR NO Norway nor no Norwegian dd.MM.yyyy
NPL NP Nepal nep ne Nepali yyyy-mm-dd
NZL NZ New Zealand eng en English dd/MM/yyyy
OMN OM Oman ara ar Arabic dd/MM/yyyy
PAK PK Pakistan urd ur Urdu dd/mm/yyyy
PAN PA Panama spa es Spanish MM/dd/yyyy
PER PE Peru spa es Spanish dd/MM/yyyy
PHL PH Philippines eng en English MM/dd/yyyy
POL PL Poland pol pl Polish dd.MM.yyyy
PRI PR Puerto Rico spa es Spanish MM-dd-yyyy
PRT PT Portugal por pt Portuguese dd-MM-yyyy
PRY PY Paraguay spa es Spanish dd/MM/yyyy
QAT QA Qatar ara ar Arabic dd/MM/yyyy
ROU RO Romania ron ro Romanian dd.MM.yyyy
RUS RU Russia rus ru Russian dd.MM.yyyy
RWA RW Rwanda kin rw Kinyarwanda dd/mm/yyyy
SAU SA Saudi Arabia ara ar Arabic dd/MM/yyyy
SCG CS Serbia and Montenegro srp sr Serbian yyyy-mm-dd
SDN SD Sudan ara ar Arabic dd/MM/yyyy
SEN SN Senegal fra fr French dd/mm/yyyy
SGP SG Singapore zho zh Chinese dd/MM/yyyy
SGP SG Singapore eng en English MM/dd/yyyy
SGS GS Georgia geo ka Georgian yyyy-mm-dd
SLV SV El Salvador spa es Spanish MM-dd-yyyy
SRB RS Serbia srp sr Serbian yyyy-mm-dd
SVK SK Slovakia slk sk Slovak yyyy-mm-dd
SVN SI Slovenia slv sl Slovenian dd-mm-yyyy
SWE SE Sweden swe sv Swedish yyyy-MM-dd
SYR SY Syria ara ar Arabic dd/MM/yyyy
THA TH Thailand tha th Thai dd/mm/yyyy
TUN TN Tunisia ara ar Arabic dd/MM/yyyy
TUR TR Turkey tur tr Turkish dd.MM.yyyy
TWN TW Taiwan zho zh Chinese mm-dd-yyyy
TZA TZ Tanzania swa sw Swahili dd/mm/yyyy
UGA UG Uganda eng en English dd/mm/yyyy
UKR UA Ukraine ukr uk Ukrainian dd.MM.yyyy
URY UY Uruguay spa es Spanish dd/MM/yyyy
USA US United States eng en English mm-dd-yyyy
USA US United States spa es Spanish mm-dd-yyyy
UZB UZ Uzbekistan uzb uz Uzbek yyyy-mm-dd
VEN VE Venezuela spa es Spanish dd/MM/yyyy
VNM VN Vietnam vie vi Vietnamese dd/MM/yyyy
YEM YE Yemen ara ar Arabic dd/MM/yyyy
ZAF ZA South Africa eng en English yyyy/MM/dd
@avelzo
Copy link
Author

avelzo commented Mar 31, 2023

Based on :
https://www.ibm.com/docs/en/db2/11.5?topic=considerations-date-time-formats-by-territory-code
https://gist.github.com/mlconnor/1887156
and https://www.loc.gov/standards/iso639-2/php/code_list.php

@avelzo
Copy link
Author

avelzo commented Mar 31, 2023 •
edited

with mysql:

CREATE TABLE countries_date_format (
ISO3 CHAR(3),
ISO2 CHAR(2),
country VARCHAR(200),
ISO3_lang CHAR(3),
ISO2_lang CHAR(2),
language VARCHAR(64),
date_format VARCHAR(32)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;

LOAD DATA LOCAL INFILE '[PATH]/countries_date_format.csv' INTO TABLE countries_date_format FIELDS TERMINATED BY ',' ENCLOSED BY '"' (ISO3,ISO2,country,ISO3_lang,ISO2_lang,language,date_format);

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment