How to change the value of Sysdate 2005-06-29 - By Ram K
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@(protected)> wrote:
> I think this is it actually
>
> ALTER SYSTEM SET FIXED_DATE=NONE;
>
> On 6/30/05, David Sharples <davidsharples@(protected)> wrote:
> > try alter system reset fixed_date scope = both sid ='*'
> >
> > On 6/30/05, Ram K <lambu999@(protected)> 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
|
|
