PDA

Click to See Complete Forum and Search --> : need SQL help

linh1417
03-27-2001, 06:37 PM
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]
m1l
03-28-2001, 06:16 AM
You could order by

to_date(CHARACTER_FIELD, 'DD-YY')

This converts the character field to the first day of that month.