Postgres Date Functions

From: Robert Hiltibidal <rob(at)y2k(dot)state(dot)il(dot)us>
To: pgsql-interfaces(at)postgreSQL(dot)org
Cc: James_Jorgensen(at)cms(dot)state(dot)il(dot)us
Subject: Postgres Date Functions
Date: 1999-11-17 17:18:14
Message-ID: 3.0.6.32.19991117111814.0095ba20@y2k.state.il.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tim Joyce 1999-11-17 18:18:38 Re: [INTERFACES] Postgres Date Functions
Previous Message Ales Pour 1999-11-17 15:30:41