Re: calculating elapsed times between timestamps

On Mon, Feb 2, 2009 at 5:54 PM, rhubbell <Rhubbell(at)ihubbell(dot)com> wrote:
>
> I want to find the length of those intervals.
>
> select timestamp, timeelapsed, bobble from perf where bobble like "pokerflat"
> and timeelapsed > 0.4;
>
> The records returned by that query will have an oldest and newest timestamp for
> which I would like to calculate the interval.

The easiest way is to just subtract one timestamp from another... If
you want the difference in seconds, then use extract

select '2009-01-31 12:34'::timestamp - '2009-01-12 15:34'::timestamp;
?column?
------------------
18 days 21:00:00
select extract(epoch from '2009-01-31 12:34'::timestamp - '2009-01-12
15:34'::timestamp);
date_part
-----------
1630800

Does that get you closer to an answer?