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 = 72date / 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/
