Date_format()?

[lukeurtnowski]

Does anyone know why this query isnt wworking?
ok, I put it in a select statment (you're soo helpful, thank you)
select DATE_FORMAT('a_date', '%d/%m/%Y') from activity order by a_date;
but it doesn't return anything?

I'm trying to return a_date in the format mm/dd/yyyy.
Thanks, all

[devinemke]

SELECT DATE_FORMAT(a_date, '%d/%m/%Y') AS a_date_formatted FROM activity ORDER BY a_date