Hello,
I'm inserting date into oracle as
To_Date('02/12/97','mm/dd/yy')
from front end ie..thru ASP.
but when i fetch the same record from the DB , it is giving the year as 2097, instead 97.
can anyone tell why?
when i write a query in SQL* Plus it gives me
13-FEB-97
I'm inserting date into oracle as
To_Date('02/12/97','mm/dd/yy')
from front end ie..thru ASP.
but when i fetch the same record from the DB , it is giving the year as 2097, instead 97.
can anyone tell why?
when i write a query in SQL* Plus it gives me
13-FEB-97