> > 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.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com