MySQL Forums
Forum List  »  General

date_format sorting not working
Posted by: jinu pt
Date: January 19, 2005 05:52AM

Hi
i have a query like this

select itemid,date_format(ItemDate,'%b-%d-%Y') from article order by 2

I tried sorting the date without the date_format it works fine but if i use the date_format function it doesn't sort the records .I need a sort by date..

anyone has any idea .. ??

Options: ReplyQuote


Subject
Written By
Posted
date_format sorting not working
January 19, 2005 05:52AM


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.