date math: converting interval result to seconds

Поиск
Список
Период
Сортировка
От Daniel Kelley
Тема date math: converting interval result to seconds
Дата
Msg-id Pine.BSF.4.20L2.0208191020560.60783-100000@mx1.gc.ny.otec.com
обсуждение исходный текст
Список pgsql-general
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



В списке pgsql-general по дате отправления:

Предыдущее
От: Jeff Eckermann
Дата:
Сообщение: Re: Success: Finished porting application to postgreSQL
Следующее
От: "Peter Gibbs"
Дата:
Сообщение: Re: date math: converting interval result to seconds