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@xxxxxxxxx> wrote:
> I think this is it actually
> 
> ALTER SYSTEM SET FIXED_DATE=NONE;
> 
> On 6/30/05, David Sharples <davidsharples@xxxxxxxxx> wrote:
> > try alter system reset fixed_date scope = both sid ='*'
> >
> > On 6/30/05, Ram K <lambu999@xxxxxxxxx> 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

Other related posts: