Re: RFC:: DateTime::Span::Common

On Tue, 7 Apr 2009, Terrence Brannon wrote:

> Yes, I would determine that aribtrary 1 second or nanosecond based on
> the data in my database tables. a MySQL BETWEEN clause includes its
> endpoints.

Unfortunately, BETWEEN is kind of broken.

What people generally want is:

  $x <= Column < $y

But unfortunately BETWEEN gives you:

  $x <= Column <= $y

Your solution, to subtract from $y, is not a good idea, since it's extra 
code which could break, and the math confuses the issue, which is that you 
really meant to write the first comparison.

So just suck it up and write:

   WHERE col >= ?
     AND col < ?


-dave

/*============================================================
http://VegGuide.org               http://blog.urth.org
Your guide to all that's veg      House Absolute(ly Pointless)
============================================================*/