MySQL Forums
Forum List  »  Newbie

Converting date to string
Posted by: James Elder
Date: February 13, 2009 03:37PM


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


Options: ReplyQuote

Written By
Converting date to string
February 13, 2009 03:37PM
February 13, 2009 03:56PM
February 13, 2009 09:15PM
February 13, 2009 09:51PM
February 14, 2009 02:02AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.