Re: Aggregate time data on half hour interval - Mailing list pgsql-general

From Tom Lane
Subject Re: Aggregate time data on half hour interval
Date
Msg-id 23506.964070451@sss.pgh.pa.us
Whole thread Raw
In response to Aggregate time data on half hour interval  (Lars <lars@sscsinc.com>)
Responses Re: Aggregate time data on half hour interval  (Lars <lars@sscsinc.com>)
Re: Aggregate time data on half hour interval  (Kyle <kaf@nwlink.com>)
List pgsql-general
Lars <lars@sscsinc.com> writes:
> What I would like to do though is aggregate by each half hour or maybe
> even 20 minutes. Does anyone know a good way to do this?

I don't have a *good* answer, but a brute-force way is

* convert timestamp to integer seconds with date_part('epoch', foo)
* round to a multiple of desired time interval
* convert back to timestamp for display via timestamp()

In the long run it seems like date_trunc ought to be more flexible
than it is...

            regards, tom lane

pgsql-general by date:

Previous
From: Chris Bitmead
Date:
Subject: Re: [HACKERS] Re: PRIMARY KEY & INHERITANCE (fwd)
Next
From: Thomas Lockhart
Date:
Subject: Re: Aggregate time data on half hour interval