In response to BlackMage : > > I have a question about ordering by date. I have a table with two fields and > some date > > Name(character varying) | Event_Date(timestamp with timezone) > A | 2009-09-10 5:30:00 > B | 2009-09-10- 00:00:00 > C | 2009-09-11 17:30:00 > D | 2009-09-11 07:30:00 > > > I want to order by date and then by name, so I want the result A,B,C,D. The > problem is when I do a 'SELECT * FROM table_name ORDER BY Event_Date, DESC', > it includes the actual time (HH:MM:SS) so the order comes out B,A,D,C.
Cast it to DATE, for instance: ... order by Event_Date::date desc Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
