Re: Subtracting Dates

From: Alan Mills <Alan.Mills_at_xservices.pants.fujitsu.com>
Date: Thu, 31 Jul 2003 14:14:56 +0100
Message-ID: <bgb4rb$1opl$1@news.icl.se>

"Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message news:3F290FEC.7F71471D_at_remove_spam.peasland.com...
> > Can remember
> > phoning Oracle support the first time I did it, about twelve years ago,
> > wondering why my minutes weren't ticking over. lol
>
> Just this week, I had a developer ask me why Oracle wasn't advancing the
> minutes, but the server was. The minutes were always '07' no matter what
> the hour was. He then asked me if I had changed some parameter to cause
> this....as if the ADVANCE_MINUTES=FALSE parameter even exists........
>

lol - and I'll bet you've got the ASSIGN_ROWNUM parameter still set to BEFORE_SORT haven't you? You know full well that all new developers expect it to be set to AFTER_SORT. shame on you - lol Received on Thu Jul 31 2003 - 08:14:56 CDT