MySQL chooses to use date and time, only by date

Question

Is it possible to select a datetime field from a table and a MySQL group only by date?

I am trying to list the events that occur several times, grouped by the date on which it occurred.

My table / data looks like this: ( timestamp is a datetime field )

1. 2010-03-21 18:00:00 Event1 2. 2010-03-21 18:30:00 Event2 3. 2010-03-30 13:00:00 Event3 4. 2010-03-30 14:00:00 Event4 

I want to output something like this:

 March 21st 1800 - Event 1 1830 - Event 2 March 30th 1300 - Event 3 1400 - Event 4 

Thanks!

Answer 1

 SELECT DATE_FORMAT(date_column, '%H%i'), DATE_FORMAT(date_column, '%M %D'), event FROM table ORDER BY date_column 

%H%i - 1830

%M%D - March 21st

Answer 2

select date_format (created_at, "% Ym-% d") as the date from tablename GROUP BY date

OR

SELECT DATE_FORMAT (date_column, '% H% i') as time, event FROM table ORDER BY DATE_FORMAT (date_column, '% Y-% m-% d'), time