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