Home > mailing lists

Extracting time - Mailing list pgsql-general

From	Krog, Kenneth
Subject	Extracting time
Date	October 1, 2001 16:34:43
Msg-id	2B592A1461C5D411919B0002A51350A204B36A5C@exch9.private.massmutual.com Whole thread Raw
Responses	Re: Extracting time (Keary Suska <hierophant@pcisys.net>)
List	pgsql-general

Tree view

 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

pgsql-general by date:

From: Keary Suska
Date: 01 October 2001, 15:20:28
Subject: Re: UNIQUE constraint and indexing

From: Keary Suska
Date: 01 October 2001, 17:49:53
Subject: Re: Extracting time

Extracting time - Mailing list pgsql-general

Previous

Next