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: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces

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.




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

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