Re: interval to seconds conversion. How?

Поиск
Список
Период
Сортировка
От Robby Russell
Тема Re: interval to seconds conversion. How?
Дата
Msg-id 1098917114.4435.39.camel@vacant
обсуждение исходный текст
Ответ на interval to seconds conversion. How?  (Denis Zaitsev <zzz@anda.ru>)
Список pgsql-general
On Thu, 2004-10-28 at 04:08 +0600, Denis Zaitsev wrote:
> How can I calculate the number of second in some interval?  Neither
> the secods part, nor the seconds after midnight...  Just the full
> quantity of the seconds.  I haven't find any function.
>
> Thanks in advance.
>

SELECT extract(epoch FROM n);

n = interval

-Robby

--
/***************************************
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON  | www.planetargon.com
* Portland, OR  | robby@planetargon.com
* 503.351.4730  | blog.planetargon.com
* PHP/PostgreSQL Hosting & Development
* --- Now supporting PHP5 and PHP4 ---
****************************************/

Вложения

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Question Regarding Locks
Следующее
От: Thomas Hallgren
Дата:
Сообщение: Re: Reasoning behind process instead of thread based