Re: order a date dual select
From: gareth hoy <ghoy_at_plusconsultancy.co.uk>
Date: 21 Dec 2002 03:11:50 -0800
Message-ID: <82cb01aa.0212210311.6de76939_at_posting.google.com>
Date: 21 Dec 2002 03:11:50 -0800
Message-ID: <82cb01aa.0212210311.6de76939_at_posting.google.com>
Thank you rajXesh,
This is just what i was after
merry chirstmas,
Gareth
rajXesh <member_at_dbforums.com> wrote in message news:<2305961.1040400269_at_dbforums.com>...
> 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
Received on Sat Dec 21 2002 - 12:11:50 CET