Re: Setting SYSDATE to January 5, 2000

From: tmgn <tmgn_at_excite.com>
Date: Wed, 14 Jul 1999 13:51:13 -0400
Message-ID: <378CCE11.6A2241CF@excite.com>

Unfortunatly, sysdate will always get the date from the operating system setting. There is no way to set it to a particular value.

One possible option would be to not use sysdate, but to create a table with a particular date and use this table instead of sysdate. If you are doing some sort of plsql programing, you can set a variable to a specific date and use that.

Other option is to use the parameter FIXED_DATE in init.ora file so that it returns the same date you specify irrespective of the OS Date

-Thiru

Frank Siegel wrote:

> Thanks in advance for any help you may provide.
>
> Is there a way to set SYSDATE to year 2000 without
> touching the system date in UNIX? We need this for
> Y2K testing and it would be a major league inconvience
> concerning UNIX crons and backups if we have to touch
> UNIX dates.
>
> Thanks again,
> Frank S.
> New Hampshire
Received on Wed Jul 14 1999 - 12:51:13 CDT