Extracting time

From: "Krog, Kenneth" <KAKrog(at)MassMutual(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Extracting time
Date: 2001-10-01 17:09:02
Message-ID: 2B592A1461C5D411919B0002A51350A204B36A5C@exch9.private.massmutual.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am attempting to do a query for a specific time based of a response for
a web site using php as the engine.
The syntax of the sql is simple

"SELECT * FROM table WHERE EXTRACT(MINUTE FROM fieldname)=$var;"

Specifically I am trying to pull up the last 30 minutes worth of data that
someone entered.

Thanks in advance

Responses

Browse pgsql-general by date

  From Date Subject
Next Message R Talbot 2001-10-01 17:21:24 Perl and PostgreSQL 7.1.2 a DBI Connection
Previous Message Keary Suska 2001-10-01 16:15:32 Re: UNIQUE constraint and indexing