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 .. ??
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.