I think you want to check if: (date BETWEEN 17:00 and 17:59) AND (finishTime BETWEEN 17:00 and 17:59)
Regards Gary > > Think you are misreading the dates > > > Am i misunderstanding this function? How would i structure the query so > that i could match on all three times? > > TIA. > Ricardo. > > > > > > > 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/
