Thread: Re: Ordering YYYY MM DD in reverse chrono order

Re: Ordering YYYY MM DD in reverse chrono order

From
"Lee Harr"
Date:
>
>ORDER BY
>date_part('year', uu.add_date), date_part('month', uu.add_date),
>date_part('day',  uu.add_date) DESC;
>


How about just

ORDER BY uu.add_date DESC

?

It would be cheaper without all of those date_part calls, and should
order in the same way.

_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail