Re: SETTING THE ORACLE DATE

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Fri, 09 Apr 1999 04:26:40 GMT
Message-ID: <371258b5.4124154@netnews.worldnet.att.net>

>As you all know, come yr 2000, a substraction of SYSDATE -
>PASSWORD_CREATE_DATE will not work cos Oralce stores dates as DD-MON-YY.

It should work. Oracle does store the full you. It's just that the default display format does not show it.

>Basically, I need to know how to alter the
>Oracle clock so that SELECT SYSDATE FROM DUAL returns a date in 2000 (to
>whatever i set the Oracle clock to), instead of today's date.

We've been doing this ourselves lately. On our HP-UX box, we had to change the system date. That carried through to Oracle.

regards,

Jonathan Received on Thu Apr 08 1999 - 23:26:40 CDT