[thelist] MYSQL: getting distinct dates from a DATETIME field

[Tab Alleman]

Dunstan Orchard wrote:
> Hi there,
> 
> Given the following dates (stored in the DATETIME fields of three
> seperate records) can anyone tell me how I can alter my MYSQL query
> to return records with distinct dates - while ignoring the
> hour:min:sec bit? 
> 
> 2003-05-15 16:00:00
> 2003-05-16 08:00:00
> 2003-05-16 16:00:00
> 
> $query = "SELECT DATE_FORMAT(event_date, '%b %D') AS event_dates,
> event_cost, event_name FROM event ORDER BY event_date ASC";

$query = "SELECT DATE_FORMAT(event_date, '%b %D') AS event_dates,
event_cost, event_name FROM event ORDER BY event_date ASC
GROUP BY MONTH(event_date), DAY(event_date);"