Postgres Pro
Downloads
Home   >   mailing lists

Selecting the most recent date - Mailing list pgsql-general

From Mark Tessier
Subject Selecting the most recent date
Date
Msg-id 20030428132655.61d9f055.m_tessier@sympatico.ca
Whole thread Raw
Responses Re: Selecting the most recent date  ("Jay O'Connor" <joconnor@cybermesa.com>)
Re: Selecting the most recent date  (Dennis Gearon <gearond@cvc.net>)
Re: Selecting the most recent date  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
Re: Selecting the most recent date  (Mark Tessier <m_tessier@sympatico.ca>)
List pgsql-general
Tree view 
Hi,

My question is hopefully a simple one:  If I have several rows, each containing a date field, and I want to select the
rowthat has the date closest to today's date, what would be the syntax for carrying that out. 

--
Thanks,

Mark

pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: Re: Setting a field to default if blank value
Next
From: Ralph Graulich
Date:
Subject: Re: problems restoring 7.2.1 dump to 7.3.2