Converting date to string

[James Elder]

Hello,

i have a very basic table which includes dates and i want to return the most recent date in the format 'Friday 13th February 2008'. I have managed to get the most recent date using the following command:

SELECT date FROM fixtures ORDER BY date DESC LIMIT 1;

from this i have then tried playing around with the date_format function to get it into the format I want, but i am not geting anywhere. Is it possible to do all this in one line?

Thanks in advance

J