SELECT on a table with Time values

From: Anderson dos Santos Donda <andersondonda(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: SELECT on a table with Time values
Date: 2009-02-04 20:05:10
Message-ID: ad072ae30902041205p2b4ee2dlefe718bb26e65c1c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all!!

I have a simple table with two column. The first column is a time type and
the other is a integer type. This table have datas from each minute of day.

Example : 15:00:00, 15:01:00, 15:02:00 etc...

I want a SELECT command wich return for me the datas from each five minutes
of day.

Example: 15:00:00, 15:05:00, 15:10:00, 15:15:00 etc

There is a way to do this?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2009-02-04 20:15:20 Re: SELECT on a table with Time values
Previous Message Thomas Finneid 2009-02-04 19:34:01 case sensitive db name?