RE: Change sysdate in database to a future date

Check out DB init parameter FIXED_DATE. It allows you to set the date to either in the future or in the past. When you select SYSDATE, it will get the date from this parameter instead of the true system date.

-----Original Message-----
Sent: Thursday, December 06, 2001 10:45 PM To: Multiple recipients of list ORACLE-L

Hi Gurus,

I need to change the sysdate in the database to a future date. Does anyone
know the command to do it ? Please advise. Thanks.

Regds,
New Bee

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  INET: clchan_at_nie.edu.sg

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing)..
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tieu, Linh K.
  INET: TieuLK_at_jea.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).