Oracle DATE sorting help

[saintdw]

I have a table with following type of data inserted

DATE ('02-5-2005') i.e. the output of that would be "2-May-05"


The problem is, when I try to do a ORDER BY date, date being a column with dates, it onle sorts them by first digit, i.e. "2" and doesnt consider month or year.

What am I doing wrong?

[Weirfire]

Have you tried using a timestamp? You can always change the way the date is displayed once you extract the date. I dont know how this is done for Oracle however as I'm more used to MySQL.

[saintdw]

I figured it out.

When i created table I used varchar2 instead of DATE. :o

[Weirfire]

:) Thought it might have been something like that.