Aage,

> -----Original Message-----
> From: Aage Johansen [mailto:aagjohan@...]
> Sent: Wednesday, September 28, 2005 3:20 PM
>
> 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.


Bob M..