From: | otis_usenet(at)yahoo(dot)com (OtisUsenet) |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Ordering YYYY MM DD in reverse chrono order |
Date: | 2004-04-21 09:19:44 |
Message-ID: | 5606b639.0404210119.4d669f45@posting.google.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I am trying to select distinct dates and order them in the reverse
chronological order. Although the column type is TIMESTAMP, in this
case I want only YYYY, MM, and DD back.
I am using the following query, but it's not returning dates back in
the reverse chronological order:
SELECT DISTINCT
date_part('year', uu.add_date), date_part('month', uu.add_date),
date_part('day', uu.add_date)
FROM uus INNER JOIN ui ON uus.user_id=ui.id INNER JOIN uu ON
ui.id=uu.user_id
WHERE uus.x_id=1
ORDER BY
date_part('year', uu.add_date), date_part('month', uu.add_date),
date_part('day', uu.add_date) DESC;
This is what the above query returns:
date_part | date_part | date_part
-----------+-----------+-----------
2004 | 2 | 6
2004 | 4 | 20
(2 rows)
I am trying to get back something like this:
2004 4 20
2004 4 19
2004 2 6
...
My query is obviously wrong, but I can't see the mistake. I was
wondering if anyone else can see it. Just changing DESC to ASC, did
not work.
Thank you!
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Kelly | 2004-04-21 10:17:31 | Re: convert result to uppercase |
Previous Message | Tanveer | 2004-04-21 06:54:26 | Distribution License Enquiry |