NLS_TERRITORY

Valid Day Values of Week for Different NLS_DATE_LANGUAGE

by Ed Chen
September 21, 2019October 3, 2019

In this post, I listed valid day values of some NLS_DATE_LANGUAGE other than AMERICAN and ENGLISH for you as a reference in order to solve… 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, 2019January 22, 2021

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 »

NLS_LANGUAGE to NLS_TERRITORY Mapping Table

by Ed Chen
September 16, 2019October 2, 2019

NLS_LANGUAGE to NLS_TERRITORY Here in this post is the mapping table for showing NLS_LANGUAGE to their respective NLS_TERRITORY. 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, 2019January 22, 2021

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 »

NLS_LANG, How and Why

by Ed Chen
September 7, 2019January 22, 2021

What is NLS_LANG? What is NLS_LANG? NLS_LANG is an environment variable in the client's environment, it's also a notation that can notify database what NLS… Read More »

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

by Ed Chen
May 17, 2019January 22, 2021
2 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 »