Re: Pl Help : How to change Oracle date without changing Unix date !!!!

You can include the FIXED_DATE parameter in your init.ora file. When the instance restarts, the value for SYSDATE will be "fixed" at whatever your setting is. Here is an example (our nls_date_format is "DD-MON-YYYY"): fixed_date = 19-JAN-1993

Mike

> Hi,
>
> I am doing some testing of my code. For that I have to change the
> oracle
> date ie. SYSDATE. But I cannot change the Unix date as other time
> bound
> applications are running in that machine.
>
> Can anyone help me by providing me a solution?
>
> Thanks
> Regards
> Jhansi
Received on Fri Feb 13 1998 - 00:00:00 CET