Re: Century date mask & Y2K compliance

Hi Neil. How's it going matey?

Looks to me as though yer d/b's are not identically configured and the 2nd box is treating '01-Jan-2000' as 01-Jan-1900 . Can't see how the system date is involved, as you're providing a hard-coded date in your Sql. Are you setting NLS_DATE_FORMAT identically in the 2 init.ora's ? Is there any local NLS_DATE_FORMAT being set at session level, like in a login.sql? Stupid questions I know but hard to see what else it could be.

Regards

GB

Neil Emery <neil.emery_at_virgin.net> wrote in article <7rtgna$83e$1_at_nnrp1.deja.com>...
> All,
> We have a date checking algorithm which uses the century format which
> is giving inconsistent results depending on the system date
>
> This Unix box has system date set to today's date
>
> SQL> select to_char(to_date('01-jan-2000', 'dd-mon-yyyy'), 'cc') from
> dual;
>
> TO
> --
> 21
>
> SQL>
> SQL>
> SQL>
> SQL> connect to a box which has system date set to '02-jan-2000'
>
> Connected.
> SQL> /
>
> TO
> --
> 20
>
> Which is the correct century ?
>
> Thie same results occur when running against Database versions
> 7.3.3, 7.3.4 and 8.04 !!!!!
> Neil
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>
Received on Fri Sep 17 1999 - 14:05:47 CDT