Is it possible to select only the date part of a date time field and also use it to group by and order by? It's the bookings.booked_date_time field. (I think I'm now at the point of completely over complicating it - no doubt there's a simpler solution)
SELECT Count(bookings.id) AS CountOfid...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.