Woody Woodring wrote:
> I am trying to calculate a rate per second and am having trouble getting the
> number of seconds between the two timestamps to use in the formula.
>
> overview=> select extract(epoch from interval '1 day'::interval);
> date_part
> ---
> 86400
> (1 row)
>
>
I am trying to calculate a rate per second and am having trouble getting the
number of seconds between the two timestamps to use in the formula.
overview=> select extract(epoch from interval '1 day'::interval);
date_part
---
86400
(1 row)
overview=> select extract(epoch from inter