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
