MySQL Forums :: Newbie :: Converting date to string

Advanced Search

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

Subject Written By Posted
Converting date to string James Elder 02/13/2009 03:37PM
Re: Converting date to string Peter Brawley 02/13/2009 03:56PM
Re: Converting date to string Jay Alverson 02/13/2009 09:15PM
Re: Converting date to string Guelphdad Lake 02/13/2009 09:51PM
Re: Converting date to string James Elder 02/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.