HELP - Ordering by Date format
From: Barry Roomberg <barry.roomberg_at_compudata.com>
Date: Mon, 12 Sep 94 21:16:00 -0500
Message-ID: <12a.4809.905_at_compudata.com>
Date: Mon, 12 Sep 94 21:16:00 -0500
Message-ID: <12a.4809.905_at_compudata.com>
-> SELECT .., to_char(very_tarty_column, 'DD/MM/YY HH24:MI:SS', .. .. ..
-> where statements etc.. .. ORDER BY 2 ASC, ..;
-> The output of the SELECT does not matter, as I can adjust the SQL
-> results parser.
Add another field which has the date without the to_char, and order by it Received on Tue Sep 13 1994 - 04:16:00 CEST