Re: Oracle 8i expiration date (2100)
Date: Thu, 20 Sep 2001 22:52:15 GMT
Message-ID: <zquq7.28644$707.15711948_at_news2.rdc2.tx.home.com>
So, you're not planning on upgrading or anything for the next 97.5 years?
I'm sorry, I just couldn't help myself.....
"koudjo" <koudjo67_at_yahoo.com> wrote in message
news:a56c9f8c.0109201309.23a6dcb3_at_posting.google.com...
> 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)
Received on Fri Sep 21 2001 - 00:52:15 CEST