Quick Links

Selecting the most recent date

From:	Mark Tessier <m_tessier(at)sympatico(dot)ca>
To:	pgsql-general(at)postgresql(dot)org
Subject:	Selecting the most recent date
Date:	2003-04-28 17:26:55
Message-ID:	20030428132655.61d9f055.m_tessier@sympatico.ca
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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.

--
Thanks,

Mark

Responses

Re: Selecting the most recent date at 2003-04-28 18:21:08 from Dennis Gearon
Re: Selecting the most recent date at 2003-04-28 18:59:29 from Jay O'Connor
Re: Selecting the most recent date at 2003-04-28 19:07:00 from Jeff Eckermann
Re: Selecting the most recent date at 2003-04-28 20:24:43 from Mark Tessier

Browse pgsql-general by date

	From	Date	Subject
Next Message	Ralph Graulich	2003-04-28 17:51:47	Re: problems restoring 7.2.1 dump to 7.3.2
Previous Message	Dennis Gearon	2003-04-28 17:26:07	Re: Setting a field to default if blank value