NLS_DATE_FORMAT
For globalization support, here I listed its formats in difference territories. Please note that, NLS_DATE_LANGUAGE is still ENGLISH.
NLS_TERRITORY | NLS_DATE_FORMAT | Example |
---|
ALBANIA | DD.MM.RRRR | 21.05.2019 |
ALGERIA | DD-MM-RR | 21-05-19 |
AMERICA | DD-MON-RR | 21-MAY-19 |
ARGENTINA | DD/MM/RRRR | 21/05/2019 |
AUSTRALIA | DD/MON/RR | 21/MAY/19 |
AUSTRIA | DD.MM.RR | 21.05.19 |
AZERBAIJAN | DD.MM.RRRR | 21.05.2019 |
BAHRAIN | DD-MM-RR | 21-05-19 |
BANGLADESH | DD-MM-RRRR | 21-05-2019 |
BELARUS | DD.MM.RR | 21.05.19 |
BELGIUM | DD/MM/RR | 21/05/19 |
BRAZIL | DD/MM/RR | 21/05/19 |
BULGARIA | RRRR-MM-DD | 2019-05-21 |
CANADA | RR-MM-DD | 19-05-21 |
CATALONIA | DD/MM/RR | 21/05/19 |
CHILE | DD/MM/RR | 21/05/19 |
CHINA | DD-MON-RR | 21-MAY-19 |
CIS | DD.MM.RR | 21.05.19 |
COLOMBIA | DD/MM/RR | 21/05/19 |
COSTA RICA | DD/MM/RR | 21/05/19 |
CROATIA | DD.MM.RR | 21.05.19 |
CYPRUS | DD/MM/RR | 21/05/19 |
CZECH REPUBLIC | DD.MM.RR | 21.05.19 |
CZECHOSLOVAKIA | DD.MM.RR | 21.05.19 |
DENMARK | RR-MM-DD | 19-05-21 |
DJIBOUTI | DD/MM/RR | 21/05/19 |
ECUADOR | DD/MM/RRRR | 21/05/2019 |
EGYPT | DD/MM/RR | 21/05/19 |
EL SALVADOR | DD/MM/RR | 21/05/19 |
ESTONIA | DD.MM.RRRR | 21.05.2019 |
FINLAND | DD.MM.RRRR | 21.05.2019 |
FRANCE | DD/MM/RR | 21/05/19 |
FYR MACEDONIA | DD.MM.RRRR | 21.05.2019 |
GERMANY | DD.MM.RR | 21.05.19 |
GREECE | DD/MM/RR | 21/05/19 |
GUATEMALA | DD/MM/RR | 21/05/19 |
HONG KONG | DD-MON-RR | 21-MAY-19 |
HUNGARY | RR-MON-DD | 19-MAY-21 |
ICELAND | DD.MM.RRRR | 21.05.2019 |
INDIA | DD-MM-RR | 21-05-19 |
INDONESIA | DD-MM-RRRR | 21-05-2019 |
IRAQ | DD/MM/RR | 21/05/19 |
IRELAND | DD-MON-RR | 21-MAY-19 |
ISRAEL | DD-MON-RRRR | 21-MAY-2019 |
ITALY | DD-MON-RR | 21-MAY-19 |
JAPAN | RR-MM-DD | 19-05-21 |
JORDAN | DD/MM/RR | 21/05/19 |
KAZAKHSTAN | DD.MM.RRRR | 21.05.2019 |
KOREA | RR/MM/DD | 19/05/21 |
KUWAIT | DD/MM/RR | 21/05/19 |
LATVIA | RRRR.MM.DD | 2019.05.21 |
LEBANON | DD/MM/RR | 21/05/19 |
LIBYA | DD/MM/RR | 21/05/19 |
LITHUANIA | RRRR.MM.DD | 2019.05.21 |
LUXEMBOURG | DD/MM/RR | 21/05/19 |
MACEDONIA | DD.MM.RRRR | 21.05.2019 |
MALAYSIA | DD/MM/RRRR | 21/05/2019 |
MAURITANIA | DD/MM/RR | 21/05/19 |
MEXICO | DD/MM/RR | 21/05/19 |
MOROCCO | DD-MM-RR | 21-05-19 |
NEW ZEALAND | DD/MM/RR | 21/05/19 |
NICARAGUA | DD/MM/RR | 21/05/19 |
NORWAY | DD.MM.RRRR | 21.05.2019 |
OMAN | DD/MM/RR | 21/05/19 |
PANAMA | DD/MM/RR | 21/05/19 |
PERU | DD/MM/RR | 21/05/19 |
PHILIPPINES | MM/DD/RRRR | 05/21/2019 |
POLAND | RR/MM/DD | 19/05/21 |
PORTUGAL | RR.MM.DD | 19.05.21 |
PUERTO RICO | DD/MM/RR | 21/05/19 |
QATAR | DD/MM/RR | 21/05/19 |
ROMANIA | DD-MM-RRRR | 21-05-2019 |
RUSSIA | DD.MM.RR | 21.05.19 |
SAUDI ARABIA | DD/MM/RR | 21/05/19 |
SERBIA AND MONTENEGRO | DD.MM.RRRR | 21.05.2019 |
SINGAPORE | DD/MM/RR | 21/05/19 |
SLOVAKIA | DD.MM.RR | 21.05.19 |
SLOVENIA | DD.MM.RR | 21.05.19 |
SOMALIA | DD/MM/RR | 21/05/19 |
SOUTH AFRICA | DD/MON/RR | 21/MAY/19 |
SPAIN | DD/MM/RR | 21/05/19 |
SUDAN | DD/MM/RR | 21/05/19 |
SWEDEN | RRRR-MM-DD | 2019-05-21 |
SWITZERLAND | DD.MM.RR | 21.05.19 |
SYRIA | DD/MM/RR | 21/05/19 |
TAIWAN | DD-MON-RR | 21-MAY-19 |
THAILAND | DD MON RRRR | 21 MAY 2019 |
THE NETHERLANDS | DD-MM-RR | 21-05-19 |
TUNISIA | DD-MM-RR | 21-05-19 |
TURKEY | DD/MM/RRRR | 21/05/2019 |
UKRAINE | DD.MM.RRRR | 21.05.2019 |
UNITED ARAB EMIRATES | DD/MM/RR | 21/05/19 |
UNITED KINGDOM | DD-MON-RR | 21-MAY-19 |
UZBEKISTAN | DD/MON/RR | 21/MAY/19 |
VENEZUELA | DD/MM/RR | 21/05/19 |
VIETNAM | DD-MM-RRRR | 21-05-2019 |
YEMEN | DD/MM/RR | 21/05/19 |
YUGOSLAVIA | DD.MM.RRRR | 21.05.2019 |