Cut and Paste date_format strings for MySQL
select date_format(date, '%a %D %b %Y') as formatted_date from table_name;
date is the name of your date field, and
formatted_date is a variable name which you can use to retrieve the value.
If I've missed a common date format, get in touch and I'll add it.