Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group