Hi to all,
Since we have migrated from 8 to 8i, we are noticing that users
created on 20, 21, 22 December 1999 are having their expiration date
in DBA Studio changed by the system to 25, 26, 27 March 2100. So it
looks like this:
created expire date
20-dec-1999 25-mar-2100
21-dec-1999 26-mar-2100
22-dec-1999 27-mar-2100
But for anybody created before and after that date there is no problem
at all. Even users created on the same date (20, 21, 22) which its
expiration date is not 25, 26, 27 march are OK.
I checked in DBA studio studio (all initialization parameters) the
date is NLS_DATE_FORMAT is dd-mon-yyyy.
Does anybody have an idea?
Your help is really appreciated.
Koudjo (Department of Health and Family Services)