I always seem to be digging around to find MySQL’s date formatting syntax, so here is a couple of common conversions…
select date_format(date, '%d %M %Y') as new_date from tablename
where date is the name of your date field, and new_date is the variable name which you can use to reference the value.
|‘%a %D %b %Y’||Fri 25th Apr 2009|
A more complete list of specifiers is available here.