ORDER BY date when it's a varchar
Posted by:
Lance
Date: June 01, 2005 09:33PM
Hey all, made the mistake of setting a field as a varchar which contains dates. They are all formatted the same mm/dd/yyyy but when you sort, 10,11,12 come before 9 so it's not correct.
A buddy said I might be able to use the UNIXtime or some similar function, is he correct?
Thanks in advance for any help in this.
Subject
Written By
Posted
ORDER BY date when it's a varchar
June 01, 2005 09:33PM
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.