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