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

I dont have the exact anwser but I remember that you have an Oracle parameter that allows you to set a fixed date. This way, sysdate will always return the same value. I have read this in the DBA manual.

check in this direction.

In article <34E48B50.7EE7_at_hotmail.com>, p_jhansi_at_hotmail.com wrote:
>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

Nicolas

Nissakid_at_planete.net
Microsoft Certified Product Specialist
AUI Member

The above represents my own opinion not my employer's and does not necessarily constitute the official policy of my employer. Any opinion developed through this account represent a private conversation. Received on Sun Feb 15 1998 - 00:00:00 CET