Re: Date sort???

From: Kenneth C Stahl <kstahl_at_lucent.com>
Date: Thu, 24 Jun 1999 13:59:35 -0400
Message-ID: <37727207.50D50DD8@lucent.com>

Someone has been making y2k changes to your database without thinking through the impact of the changes they made. Take a look at your initxxxx.ora file and see if there are any nls_date_format parameters. Also, if you are using sqlplus, take a look at the glogin.sql file to make sure that nothing is being done there to modify the default date format.

Unless you are working with an ancient (6.0 or earlier) rdbms then if you insert '28-may-99' into a date column, it should be stored as 28-may-1999.

Ken

Mark G wrote:

> This may sound silly but perfectly feasible.
> Is the year actually stored in the database as 28-MAY-1999 or 28-MAY-0099?
>
> If the dates were entered without the format mask not being DD-MON-YYYY but
> as DD-MON-YY, 0099 can at times be written to the database.
> The one with the year 1998 could have been entered corectly, hence appearing
> at the bottom of the list.
>
> I say this because its happend at my last place!
>
> Mark
>
>
Received on Thu Jun 24 1999 - 12:59:35 CDT