MySQL Query GROUP BY day / month / year
Is it possible I make a simple query to count how many records I have in a determined period of time like a Year, month or day, having a
TIMESTAMP field, like:SELECT COUNT(id)
FROM stats
WHERE record_date.YEAR = 2009
GROUP BY record_date.YEAR
Or even:
SELECT COUNT(id)
FROM stats
GROUP BY record_date.YEAR, record_date.MONTH
To have a monthly statistic.
Thanks!
Answer:
GROUP BY YEAR(record_date), MONTH(record_date)
Check out the date and time functions in MySQL.
http://stackoverflow.com/questions/508791/mysql-query-group-by-day-month-year/508806#508806
