Re: Interval Division Workaround Suggestions (sub-day intervals only)?

Поиск
Список
Период
Сортировка
От Chris Angelico
Тема Re: Interval Division Workaround Suggestions (sub-day intervals only)?
Дата
Msg-id CAPTjJmq4aJa_BkmEFfqzgf65GGqTdKK+xmdn9f0GHA82Oegxfw@mail.gmail.com
обсуждение исходный текст
Ответ на Interval Division Workaround Suggestions (sub-day intervals only)?  ("David Johnston" <polobo@yahoo.com>)
Список pgsql-general
Дерево обсуждения 
On Wed, May 30, 2012 at 3:50 AM, David Johnston <polobo@yahoo.com> wrote:
> Any suggestions on how to obtain the number of “X minute” intervals in “Y”
> where “Y” is always less than 24 hours?
>
> e.g., : ‘05:00:00’::interval / ’00:06:00’::interval => 50 (integer)

Turn them into integer seconds:

select date_part('epoch','05:00:00'::interval)/date_part('epoch','00:06:00'::interval);

ChrisA

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

Предыдущее
От: "David Johnston"
Дата:
Сообщение: Interval Division Workaround Suggestions (sub-day intervals only)?
Следующее
От: Raghavendra
Дата:
Сообщение: Re: Disable Streaming Replication without restarting either master or slave