Re: How to change the value of Sysdate

  • From: David Sharples <davidsharples@xxxxxxxxx>
  • To: Ram K <lambu999@xxxxxxxxx>
  • Date: Thu, 30 Jun 2005 00:16:33 +0100

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).
>
--
//www.freelists.org/webpage/oracle-l

Other related posts: