Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.
SELECT DATE_FORMAT(dates.`datum`, '%Y-%m-%d 12:00:00') AS date2, (SELECT COUNT(*) FROM bookings WHERE bookings.to >= date2 AND bookings.from <= date2) AS number_of_bookings FROM dates WHERE dates.`datum` >= '2012-01-01' AND dates.`datum` <= '2012-01-31' AND DATE_FORMAT(dates.`datum`, '%H:%i:%s') = '12:00:00'
Join the community of 500,000 technology professionals and ask your questions.