Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> order by date

order by date

From: Steffi <steffi_at_planet.de>
Date: Tue, 27 Jul 1999 11:27:04 +0200
Message-ID: <379D7B68.D3904275@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 - 04:27:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US