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

NLS_SESSION_PARAMETERS, How and Why

by Ed Chen
July 18, 2023July 24, 2023

What is NLS_SESSION_PARAMETERS ? NLS_SESSION_PARAMETERS is a dictionary view which shows all current NLS parameters of an user's session. Let's see their values. SQL> set… Read More »

NLS_INSTANCE_PARAMETERS, How and Why

by Ed Chen
July 17, 2023June 19, 2023

What is NLS_INSTANCE_PARAMETERS ? NLS_INSTANCE_PARAMETERS is a dictionary view which shows default NLS parameters of an instance. Let's see their values. SQL> set pagesize 1000;… Read More »

NLS_DATABASE_PARAMETERS, How and Why

by Ed Chen
July 14, 2023June 19, 2023

What is NLS_DATABASE_PARAMETERS ? NLS_DATABASE_PARAMETERS is a dictionary view which shows default NLS parameters of a database. Let's see their values. SQL> set pagesize 1000;… Read More »

Toad NLS_DATE_FORMAT

by Ed Chen
April 19, 2023June 10, 2023
2 Comments

How do I Change NLS Date Format in Toad ? Just like we said previously, NLS_DATE_FORMAT can be set at session, database or OS level.… Read More »

PL/SQL Developer NLS_DATE_FORMAT

by Ed Chen
April 18, 2023June 10, 2023

How do I Change NLS Date Format in PL/SQL Developer ? Just like we said previously, NLS_DATE_FORMAT can be set at session, database or OS… Read More »

SQL Developer NLS_DATE_FORMAT

by Ed Chen
April 17, 2023June 10, 2023

How do I Change NLS Date Format in SQL Developer ? Just like we said previously, NLS_DATE_FORMAT can be set at session, database or OS… Read More »

NLS_DATE_FORMAT, How and Why

by Ed Chen
April 14, 2023July 24, 2023

NLS_DATE_FORMAT defines the display format of a datetime string, which can be set at various levels to meet business requirements. That is to say, NLS_DATE_FORMAT… Read More »

How to Check Tablespace Creation Date

by Ed Chen
May 30, 2022April 15, 2023

Tablespace Create Time There's no direct way to know the creation date of a tablespace, because either DBA_TABLESPACES or V$TABLESPACE doesn't have such information. But… Read More »

How to Check Oracle Database Startup Time

by Ed Chen
September 17, 2021April 15, 2023

Startup Time Varies To check Oracle database startup or restart time, we have to know the difference between instance startup time and database open time.… Read More »

How NLS_LANG Affects NLS_DATE_FORMAT When NLS_LANG is Set Territory Only

NLS_TERRITORY to NLS_DATE_FORMAT Mapping Table

by Ed Chen
September 18, 2019April 19, 2023

NLS_TERRITORY to NLS_DATE_FORMAT Here in this post is the mapping table for showing NLS_TERRITORY to their respective NLS_DATE_FORMAT. In some situations, you may need this… Read More »

JavaScript is not enabled. Please enable it and reload the page.