Ricardo,
Your query is returning the right results in all of your 3 cases as far as I can see.
Case 1 matches because the 1st clause is satisfied.
Case 2 does not match because neither clause is satisfied.
Case 3 matches because the 2nd clause is satisfied.Regards: Ayudh +----------------------------------------------------------------+ | SOAP is the glue! Hook up your server directly to your bank. | | Connect to VeriPay xServ, the Australian Payments Web Service. | | Reliable, Secure, FAST: http://www.xilo.com/xserv | +----------------------------------------------------------------+ > Hi guys, > Can anyone tell me where i went wrong? > I can't seem to match the time if they are both within the same hour. > unless the time is on the O'clock. > > SELECT * FROM diary > WHERE (({ts '2004-06-28 17:00:00'} BETWEEN date AND finishTime) > OR ({ts '2004-06-28 17:59:00'} BETWEEN date AND finishTime )) > AND cid = 72 > > date / finishTime > 28/06/2004 5:00:00 PM 28/06/2004 5:30:00 PM - match > 28/06/2004 5:05:00 PM 28/06/2004 5:30:00 PM - no match > 28/06/2004 5:05:00 PM 28/06/2004 6:30:00 PM - match > > I'm using MySQL 4.1.1 > TIA > Ricardo. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
