I had problem of y2k kind.
When I run the below query in both development and production database I get two different results as shown below:
Select TO_CHAR(Test_Date,'DD-MM-YYYY') From Test_Table Where row_id = 1;
In Production DB:
TO_CHAR(Test_Date,'DD-MM-YYYY')
-----------------------------------
13-03-2097
In Development DB:
TO_CHAR(Test_Date,'DD-MM-YYYY')
-----------------------------------
13-03-1997
The column Test_Date is in format of DD-MM-RR
Anyone please help with the above discrepancy as I do not know the reason for it.
We are using Oracle 11g.