That’s what I was afraid of. So I’d have to take the YYYY-MM variable, add an “01” as the day and run it through some PHP coding to figure out the plus one on the month.
If you know I quick solution for adding a month I’m all ears.
WHERE video_date >= ‘2009-12-01’
AND video.date < ‘2010-01-01’
That date format works properly with datetime columns, correct? It’s working, just want to make sure it isn’t missing anything from the first day due to time.