Skip site navigation (1) Skip section navigation (2)

Re: Selecting the most recent date

From: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>
To: Mark Tessier <m_tessier(at)sympatico(dot)ca>,pgsql-general(at)postgresql(dot)org
Subject: Re: Selecting the most recent date
Date: 2003-04-28 19:07:00
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
--- 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;

Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.

In response to

pgsql-general by date

Next:From: Sergio PiliDate: 2003-04-28 19:07:32
Subject: Error: No one parent tuple was found
Previous:From: Jay O'ConnorDate: 2003-04-28 18:59:29
Subject: Re: Selecting the most recent date

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group