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
Order by
Who is online
Users browsing this forum: No registered users and 0 guests