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

Re: [INTERFACES] Postgres Date Functions

From: "Tim Joyce" <tim(at)hoop(dot)co(dot)uk>
To: <pgsql-interfaces(at)postgreSQL(dot)org>, "Robert Hiltibidal" <rob(at)y2k(dot)state(dot)il(dot)us>
Cc: <James_Jorgensen(at)cms(dot)state(dot)il(dot)us>
Subject: Re: [INTERFACES] Postgres Date Functions
Date: 1999-11-17 18:18:38
Message-ID: 006301bf3128$9dfa4260$0501a8c0@noonoo (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
 Select * from tblApplication order by EntryDate desc LIMIT 1

should work


----- Original Message -----
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>
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
> 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
> ************

In response to

pgsql-interfaces by date

Next:From: GooDate: 1999-11-17 20:56:12
Subject: PGSQL Win32 ODBC Driver works on Win2K RC2
Previous:From: Robert HiltibidalDate: 1999-11-17 17:18:14
Subject: Postgres Date Functions

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