Postgres Date Functions - Mailing list pgsql-interfaces

From Robert Hiltibidal
Subject Postgres Date Functions
Date
Msg-id 3.0.6.32.19991117111814.0095ba20@y2k.state.il.us
Whole thread Raw
List pgsql-interfaces
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



pgsql-interfaces by date:

Previous
From: Ales Pour
Date:
Subject: ...
Next
From: "Tim Joyce"
Date:
Subject: Re: [INTERFACES] Postgres Date Functions