Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Century date mask & Y2K compliance

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US