Oracle TO_DATE Function Examples
Oracle TO_DATE function can convert a string into a datetime value which is acceptable for computing or comparing values of datetime type. In other words,… Read More »Oracle TO_DATE Function Examples
ORA-01861
NLS_TERRITORY to NLS_DATE_FORMAT Mapping Table
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_TERRITORY to NLS_DATE_FORMAT Mapping Table
NLS_LANGUAGE to NLS_DATE_FORMAT Mapping Table
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_LANGUAGE to NLS_DATE_FORMAT Mapping Table
NLS_LANG, How and Why
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 »NLS_LANG, How and Why
How to Resolve ORA-01861: literal does not match format string
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 Resolve ORA-01861: literal does not match format string