[lug] postgresql query question

[George Sexton]

Is there something that converts the timestamp to seconds? If so, can 
you do:

(convert_to_seconds(date_field) modulo 60) = 0

Nick Golder wrote:
> Is there a way to query data between two timestamps based on some
> selected interval?  For example, I want to query all data for every 60
> second interval between 2004-09-10 14:00:00 and 2004-10-10 14:00:00.
> I looked at 'INTERVAL' but that appears to only show it for the first
> interval after a selected timestamp.  
> 
> TIA,
> 

-- 
George Sexton
MH Software, Inc.
Voice: +1 303 438 9585
URL:   http://www.mhsoftware.com/