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:16:33 +0100
Message-ID: <be592d5505062916162da20aac@mail.gmail.com>


I think this is it actually

ALTER SYSTEM SET FIXED_DATE=NONE; On 6/30/05, David Sharples <davidsharples_at_gmail.com> wrote:
> 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:21:57 CDT

Original text of this message

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