Order by

[sateesh]

Hi,

select distinct RTRIM(SUBSTR(to_char(start_time,'dd-month-yyyy'),4),'-2007') a FROM SHIPMENT order by a

The output is coming like
april
august
december
febrauary
january

How to get that in Sequence like
january
febrauary
march
april

Regards
Sateesh

[srinu_a47]

select distinct to_char(hiredate,'month--yyyy') as mon_year , to_char(hiredate,'mm') as mm from emp order by mm