Re: Ordering YYYY MM DD in reverse chrono order

From: Scott Ribe <scott_ribe(at)killerbytes(dot)com>
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:54:41
Message-ID: BCB28CE1.46823%scott_ribe@killerbytes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> ORDER BY
> date_part('year', uu.add_date), date_part('month', uu.add_date),
> date_part('day', uu.add_date) DESC;

You meant:

ORDER BY
date_part('year', uu.add_date) DESC, date_part('month', uu.add_date) DESC,
date_part('day', uu.add_date) DESC;

--
Scott Ribe
scott_ribe(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 665-7007 voice

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Clodoaldo Pinto Neto 2004-04-26 15:55:55 Re: Ordering YYYY MM DD in reverse chrono order
Previous Message John Sidney-Woollett 2004-04-26 15:48:41 Re: Restart increment to each year = re-invent the