Re: How to change the value of Sysdate

This worked: ALTER SYSTEM SET FIXED_DATE=NONE;

I tried ALTER SYSTEM SET FIXED_DATE=""; but not "none". Thanks

On 6/29/05, David Sharples <davidsharples_at_gmail.com> wrote:
> 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).
> >
>

-- 
Thanks,
Ram.
--
http://www.freelists.org/webpage/oracle-l