Re: order by date

If datum is date type :

ORDER BY to_char(datum,'MM.DD.YYYY')

HTH,
Philippe

Steffi wrote in message <379D7B68.D3904275_at_planet.de>...
>hi..
>I want to order my values by month.
>
>I tested this, but it's not correct:
>can anybody help me?
>
>CURSOR cdate IS
>SELECT name, datum
>FROM feiertage
>ORDER BY to_date(datum,'MM.DD.YYYY') ASC;
>.
>.
>htp.TableData(TO_CHAR(crec.datum,'DD.MM.YYYY'));
>.
>.
Received on Tue Jul 27 1999 - 05:45:27 CDT