Re: order a date dual select

The ordering is correct because you are selecting strings, not dates.

To select dates enclose it in a to_date function for eg SELECT TO_DATE('30-MAR-2001', 'dd-mon-yyyy') Transaction_Date_LOV FROM DUAL UNION
SELECT TO_DATE('06-APR-2001', 'dd-mon-yyyy') FROM DUAL UNION SELECT TO_DATE('12-APR-2001', 'dd-mon-yyyy') FROM DUAL ........

• rajXesh

--

Posted via http://dbforums.com Received on Fri Dec 20 2002 - 17:04:29 CET