From: | Clodoaldo Pinto Neto <clodoaldo_pinto(at)yahoo(dot)com(dot)br> |
---|---|
To: | OtisUsenet <otis_usenet(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Ordering YYYY MM DD in reverse chrono order |
Date: | 2004-04-26 15:55:55 |
Message-ID: | 20040426155555.59375.qmail@web40906.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Did you try
ORDER BY
date_part('year', uu.add_date) desc, date_part('month', uu.add_date) desc,
date_part('day', uu.add_date) DESC;
Regards,
Clodoaldo
--- OtisUsenet <otis_usenet(at)yahoo(dot)com> escreveu: > 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!
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
______________________________________________________________________
Yahoo! Messenger - Fale com seus amigos online. Instale agora!
http://br.download.yahoo.com/messenger/
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Ribe | 2004-04-26 15:56:19 | Re: Distribution License Enquiry |
Previous Message | Scott Ribe | 2004-04-26 15:54:41 | Re: Ordering YYYY MM DD in reverse chrono order |