Re: date math: converting interval result to seconds - Mailing list pgsql-general

Daniel Kelley wrote:

> i'm trying to do something like this:
>
> triv=> SELECT current_timestamp-stime as tm FROM triv_a_r WHERE tq_id =
> 'QM7DGLU15' AND fid_c = 'PTA42BEAE';
>           tm
> -----------------------
>  2 days 18:32:46.06146
> (1 row)
>
>
> but i'd like the resulting interval to be represented in seconds.  i've

select date_part('epoch', current_timestamp-stime)

--
Peter Gibbs
EmKel Systems