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

Fwd: 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: Fwd: Re: Selecting the most recent date
Date: 2003-04-28 21:46:23
Message-ID: 20030428214623.41946.qmail@web20802.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-general
--- 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


Responses

pgsql-general by date

Next:From: scott.marloweDate: 2003-04-28 21:59:50
Subject: Re: > 16TB worth of data question
Previous:From: Antti HaapalaDate: 2003-04-28 21:36:14
Subject: Re: timestamps and dates

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