Re: Roll Oracle 7.3.4 SYSDATE forward

From: tmgn <tmgn_at_excite.com>
Date: Thu, 22 Jul 1999 16:29:54 -0400
Message-ID: <37977F42.5FC412F0@excite.com>

You can add a line like

fixed_date = '<Year 2000 date>'

in the init.ora and bounce the database. All Further SQL queries selecting Sysdate will return the same date that you Specified as 'fixed_date' .

But I am not sure of PL/SQL code referring sysdates..Probably you can create a Dumy table for storing the date and Select from it...

-Thiru

eric_peterson_at_maurices.inrg.com wrote:

> We are in the midst of performing some final Y2K compliance testing.
> Does anyone know if it is possible to roll SYSDATE on the database
> forward without having to roll the system date on the hardware
> forward? My thoughts are it is probably impossible. But, if anyone
> has any info, please let me know.
>
> TIA
> Eric Peterson
> Programmer/Analyst DBA
> Maurices Inc.
> eric_peterson_at_maurices.inrg.com
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Thu Jul 22 1999 - 15:29:54 CDT