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

How to Check Tablespace Creation Date

by Ed Chen
May 30, 2022June 10, 2022

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, 2021January 24, 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, 2019December 10, 2022

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 »

How NLS_LANG Affects NLS_DATE_FORMAT When NLS_LANG is Set Language Only

NLS_LANGUAGE to NLS_DATE_FORMAT Mapping Table

by Ed Chen
September 14, 2019December 10, 2022

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

How to Resolve ORA-12705 Error Message

by Ed Chen
May 19, 2019December 10, 2022

ORA-12705: invalid or unknown NLS parameter value specified ORA-12705 tells you that your NLS settings are not correct, you have to fix them first before… Read More »

ORA-12705: NLSデータファイルにアクセスできないか、無効な環境が指定されましたの解決方法

by Ed Chen
May 19, 2019December 10, 2022

ORA-12705では、NLS設定が正しくないことを示しています。データベースに対して何かを実行する前に、まずそれらを修正する必要があります。この投稿にはORA-12705の2つのエラーパターンがあります。接続前のORA-12705 接続後のORA-12705 接続前のORA-12705 データベースに接続する前に故意に偽のNLS_LANGを設定しましょう。これは、Oracleが使用するために選択する環境変数です。NLS_LANGの形式については、NLS_LANG方法と理由を確認できます。 [oracle@test ~]$ export NLS_LANG=JAPAN_JAPAN.UTF8 [oracle@test ~]$ echo $NLS_LANG JAPAN_JAPAN.UTF8 データベースに接続しようとしました。 [oracle@test ~]$ sqlplus /nolog ... SQL> conn hr/hr ERROR:… Read More »

How to Resolve ORA-01861: literal does not match format string

by Ed Chen
May 17, 2019March 22, 2023
3 Comments

ORA-01861 ORA-01861 means that the format strings of DATE and CHAR between two operands are not comparable in date format, we should make them match… Read More »

How to Set NLS_DATE_FORMAT in RMAN

by Ed Chen
October 9, 2012March 22, 2023

NLS_DATE_FORMAT for RMAN After you set RMAN log location, the next problem that you want to solve is the format of timestamp in the log,… Read More »