Oracle TO_DATE Example
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 Example
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
In this post, I'll talk about 3 major topics about NLS_LANG. What is NLS_LANG? How to Set NLS_LANG in Oracle? What are Available Values of… 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 date format between two operands cannot be comparable. Usually, it happens when comparing DATE with CHAR. Therefore, we should make… Read More »How to Resolve ORA-01861: literal does not match format string