From: | BlackMage <dsd7872(at)uncw(dot)edu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Order By Date Question |
Date: | 2009-09-08 13:29:28 |
Message-ID: | 25346259.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
So what I am asking is how do I order only by the date? YYYY-MM-DD?
--
View this message in context: http://www.nabble.com/Order-By-Date-Question-tp25346259p25346259.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Kristian Larsson | 2009-09-08 13:58:25 | Adding integers ( > 8 bytes) to an inet |
Previous Message | Markus Pscheidt | 2009-09-08 13:28:43 | Re: Fail to start Postgres on Ubuntu kernel 2.6.28-15-generic |