Century date mask & Y2K compliance

From: Neil Emery <neil.emery_at_virgin.net>
Date: Fri, 17 Sep 1999 13:46:22 GMT
Message-ID: <7rtgna$83e$1@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 - 08:46:22 CDT