Re: date ranges

[Bruce Feist]

Bruce Feist wrote:

Instead, if the four dates are s1, e1, s2, and e2 (s=start, e=end), we
     

want:
 

s1 <= e2 /* first range can't start after second range ends */
AND
s2 <= e1 /* second range can't start after first range ends */   

Bruce Feist also wrote:

Your original suggestion works if the two ranges partially 
overlap, but not if one is wholly contained in the other.

Jones, Clifton R [CC] wrote:

Not true... a pencil and paper excercise shows it does, indeed, work.
 

What you quoted above wasn't Matt's original suggestion; it was my 
suggested alternative based on my above comments.  So, yes, I believe it 
works.  The original, and a counterexample I came up with for it, is in 
an earlier post.

Bruce Feist



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]