MySQL group by day with TIMESTAMP column

I have a mysql table that has a colum开发者_开发技巧n for "date time" in TIMESTAMP format. Is there a way to group the rows by day using that column? And in an SQL query, not grouping them in php.

---

Assuming your column is one of the Date and Time types:

SELECT ... GROUP BY DATE(`datetimecolumn`)

---

GROUP BY TO_DAYS(`datetime_column`)

---

If you mean you have a standard DATETIME column, you can group by using one of the functions described here.

For instance:

GROUP BY DATE(datetime_column);

If you actually have a TEXT or VARCHAR column (your answer doesn't specify), then you'll need to convert it to to a date first:

GROUP BY DATE(STR_TO_DATE(datetime_column));