Martijn,

> -----Original Message-----
> From: Martijn Tonies [mailto:m.tonies@...]
> Sent: Thursday, September 29, 2005 10:37 AM
>
> > > Bob Murdoch wrote:
> > > > ...
> > > > I am running the following query:
> > > >
> > > > update
> > > > sku_price
> > > > set
> > > > end_date = (end_date + 1) - (1/24/60/60)
> > > > ...
> > >
> > >
> > > Isn't this equivalent to
> > > end_date = (end_date + 1) - 0
> >
> > No. My query subtracts 1 second from the next day,
> effectively adding
> > 23 hours, 59 minutes, and 59 seconds to END_DATE.
>
> Not in a dialect 3 database it doesn't.

Whew, good thing I'm working on a dialect 1 db!

<g>


Bob M..