Fwd: Re: Selecting the most recent date

--- Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com> wrote:
> Date: Mon, 28 Apr 2003 12:07:00 -0700 (PDT)
> From: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>
> Subject: Re: [GENERAL] Selecting the most recent
> date
> To: Mark Tessier <m_tessier(at)sympatico(dot)ca>,
> pgsql-general(at)postgresql(dot)org
>
> --- Mark Tessier <m_tessier(at)sympatico(dot)ca> wrote:
> > Hi,
> >
> > My question is hopefully a simple one: If I have
> > several rows, each containing a date field, and I
> > want to select the row that has the date closest
> to
> > today's date, what would be the syntax for
> carrying
> > that out.
> >
> select * from tablename order by abs(current_date -
> datefield) desc limit 1;
>
Whoops, that "desc" should not be there: that would
get you the opposite result to the one you want ;-)
Sorry for the (my) confusion.

__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com