Order by
Posted: Fri Mar 30, 2007 7:55 am
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
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