Date Format - Year is displayed incorrectly
Oracle is currently working on an SR on this topic, while we are diagnosing the problem we are opening up this question to our user community so they can add perspective to the solution based on their real world experience
We are trying to do select and the output is
select TO_CHAR(BIRTH_DT, 'dd/mm/yyyy') from TBL_PERSON where IP_C2O_NO = 'C0929476/CT/A';
TO_CHAR(BI
----------
01/01/0019
Below are the NLS settings
SQL> select * from nls_database_parameters order by 1;
PARAMETER VALUE
------------------------------ --------------------------------------------------
NLS_CALENDAR GREGORIAN
NLS_CHARACTERSET UTF8
NLS_COMP BINARY
NLS_CURRENCY $
We are trying to do select and the output is
select TO_CHAR(BIRTH_DT, 'dd/mm/yyyy') from TBL_PERSON where IP_C2O_NO = 'C0929476/CT/A';
TO_CHAR(BI
----------
01/01/0019
Below are the NLS settings
SQL> select * from nls_database_parameters order by 1;
PARAMETER VALUE
------------------------------ --------------------------------------------------
NLS_CALENDAR GREGORIAN
NLS_CHARACTERSET UTF8
NLS_COMP BINARY
NLS_CURRENCY $
0