Postgres Pro
Downloads
Home   >   mailing lists

SELECT on a table with Time values - Mailing list pgsql-general

From Anderson dos Santos Donda
Subject SELECT on a table with Time values
Date
Msg-id ad072ae30902041205p2b4ee2dlefe718bb26e65c1c@mail.gmail.com
Whole thread Raw
Responses Re: SELECT on a table with Time values
List pgsql-general
Tree view
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?

pgsql-general by date:

Previous
From: David Wall
Date:
Subject: Array, bytea and large objects
Next
From: "Dann Corbit"
Date:
Subject: Re: SELECT on a table with Time values