Re: Order By problem with Dates

You are allowed to 'order by' something that does not appear in the select list, so you can do this:

select distinct to_char(to_date(substr(to_char(s_date),1,4)||'-'||substr (to_char(s_date),5,2)||'-'||substr(to_char(s_date),7,2),'YYYY-MM- DD'),'Mon DD, YYYY')
from tssds.ehefmsam
where locdesc = 'MW-8'
order by s_date
;

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk Received on Tue Aug 17 1999 - 15:46:53 CDT