From: Tim Joyce <tim@hoop.co.uk>
To: pgsql-interfaces@postgreSQL.org
To: Robert Hiltibidal <rob@y2k.state.il.us>
Cc: James_Jorgensen@cms.state.il.us
Subject: Re: [INTERFACES] Postgres Date Functions
Date: Wed, 17 Nov 1999 18:18:38 -0000
Message-ID: <006301bf3128$9dfa4260$0501a8c0@noonoo> (raw)
References: <3.0.6.32.19991117111814.0095ba20@y2k.state.il.us>
Select * from tblApplication order by EntryDate desc LIMIT 1
should work
timj
----- Original Message -----
From: Robert Hiltibidal <rob@y2k.state.il.us>
To: <pgsql-interfaces@postgreSQL.org>
Cc: <James_Jorgensen@cms.state.il.us>
Sent: 17 November 1999 17:18
Subject: [INTERFACES] Postgres Date Functions
> Afternoon,
>
> Here's a thorny problem:
>
> Given I have a field called entrydate and is set to type datetime, what is
> the best way to pull the latest entry into that record basing the query
off
> of entrydate?
>
> Currently I am using something like:
>
> Select * from tblApplication order by EntryDate desc
>
> That query pulls all the records. I wish to pull only one.
>
> Thanks,
>
> -Rob
>
>
> ************
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tim@hoop.co.uk, rob@y2k.state.il.us, James_Jorgensen@cms.state.il.us
Subject: Re: [INTERFACES] Postgres Date Functions
In-Reply-To: <006301bf3128$9dfa4260$0501a8c0@noonoo>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox