Recent content by chesty

Thank you for your input on this guys and sorry for late reply. I got it in the end with the below query. Slightly different to Skypanthers suggestion and handles all points mentioned by largerrabbit. SELECT * FROM `test` WHERE end_date > qstarttime AND start_date < qendtime...

Hi All, I have a SQL date range query I need help with. I have a mysql table called 'Booking' that has a number of fields with 2 being of type 'datetime' - 'start_date' and 'end_date'. I want to be able to query the two fields to see if a query date range falls within any of the...