Re: Y2K question!!

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 10 Sep 1999 08:39:34 +0100
Message-ID: <936949578.11809.0.nnrp-07.9e984b29@news.demon.co.uk>

Remember that by 31-Dec-1999 7.3.4 will be the lowest supported version of Oracle.

Apart from that, your test needs a re-write.
> select to_char(to_date(last_day('01-feb-00'),'dd-mon-
rr'),'MM/DD/RRRR')
> from dual

The last_day() call has already returned 28-feb-00 (meaning 1900) before you apply the to_date() function.

Try (e.g. unless I have the brackets wrong):

select
to_char(last_day(to_date('01-feb-2000','dd-mon-yyyy')),'mm/dd/yyyy')

from dual;

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk Received on Fri Sep 10 1999 - 02:39:34 CDT