Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to change the value of Sysdate
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-lReceived on Wed Jun 29 2005 - 19:21:57 CDT
![]() |
![]() |