If i have a month column in "MM/YY" fromat, how do I order it by date order (month) desc, instead of alphabetic order?
[Edited by linh1417 on 03-27-2001 at 05:40 PM]
Printable View
If i have a month column in "MM/YY" fromat, how do I order it by date order (month) desc, instead of alphabetic order?
[Edited by linh1417 on 03-27-2001 at 05:40 PM]
You could order by
to_date(CHARACTER_FIELD, 'DD-YY')
This converts the character field to the first day of that month.