Problem:
All year 1999 become 2000 when I fetch table data with SQL query from a third party web app (the web app has a SQL query box)
What we have tried:
Query the data directly from Oracle DB Management tool yet the year outputs 19** which is totally fine.
https://stackoverflow.com/questions/33562929/oracle-date-conversion-outputs-2000s-instead-of-required-1990s. Tried different variety of queries based on this discussion on stackoverflow.
Any idea what might be the root of the issue? Cheers!