Re: Y2k Problem with 7.3.4

What is the NLS_DATE_FORMAT as defined (or not) in your init.ora ?

If 'dd-mon-yy' , or not explicitly set, then '01-Jan-00' (without the explicit RR mask)
means '01-Jan-1900', and the Sql is correct

Please mail me for further advice by all means. This stuff is affected heavily by your Forms and 'Developer'
versions also. You might have much work to do . (We're in the middle of it right now)

Regards

Glenn Baron

Carl A. Dotger <dotman23_at_fast.net> wrote in article <7bh5is$hkr$1_at_news1.fast.net>...
> When selecting back date related data from a table, Oracle seems to
natively
> order dates with respect to a two digit year. For Example:
>
> select end_date from period_setup
> order by end_date
>
>
> The above SQL returns something like
>
> 1-Jan-00
> 1-Jan-98
> 1-Jan-99
>
> Obviously, the '00' entries pertain to the year 2000 so this result set
is
> incorrect. Oracle support says that using the century specific date mask
> (ie. 'DD-MON-RR') will return the correct results and it really does seem
to
> work. The problem is that we have much source code that would have to
> change. I am interested in the lowest impact solution to this issue.
Please
> Help!
>
> TIA,
>
> Carl Dotger
>
>
>
>
>
>
>
Received on Tue Mar 02 1999 - 12:04:39 CST