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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
Select * from tblApplication order by EntryDate desc LIMIT 1
should work
timj
----- 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
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
>
>
> ************
From | Date | Subject | |
---|---|---|---|
Next Message | Goo | 1999-11-17 20:56:12 | PGSQL Win32 ODBC Driver works on Win2K RC2 |
Previous Message | Robert Hiltibidal | 1999-11-17 17:18:14 | Postgres Date Functions |