date math: converting interval result to seconds

Started by Daniel Kelleyover 23 years ago2 messagesgeneral
Jump to latest
#1Daniel Kelley
dkelley@otec.com

hi-

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
looked through the various date functions in the docs (date_part,
date_trunc, extract), and none of them seem to do this. are there any
such date conversion functions?

i'm using 7.2.1 on solaris 8.

thanks-

dan

#2Peter Gibbs
peter@emkel.co.za
In reply to: Daniel Kelley (#1)
Re: date math: converting interval result to seconds

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