Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to change the value of Sysdate

Re: How to change the value of Sysdate

From: David Sharples <davidsharples_at_gmail.com>
Date: Thu, 30 Jun 2005 00:13:14 +0100
Message-ID: <be592d5505062916134e44dddf@mail.gmail.com>


try alter system reset fixed_date scope = both sid ='*'

On 6/30/05, Ram K <lambu999_at_gmail.com> wrote:
> I was playing around with setting the fixed_date. I was able to set it
> to some other date. But I cant set it back to current date (sysdate).

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 29 2005 - 19:18:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US