Re: More straight forward method to convert seconds::bigint to interval

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: More straight forward method to convert seconds::bigint to interval
Дата
Msg-id
7350.1253738484@sss.pgh.pa.us
Ответ на
More straight forward method to convert seconds::bigint to interval (Shane R. Spencer)
Список
Дерево обсуждения
More straight forward method to convert seconds::bigint to interval "Shane R. Spencer" <shane@bogomip.com>
Re: More straight forward method to convert seconds::bigint to interval Adam Rich <adam.r@sbcglobal.net>
Re: More straight forward method to convert seconds::bigint to interval Shane Spencer <shane@bogomip.com>
Re: More straight forward method to convert seconds::bigint to interval Tom Lane <tgl@sss.pgh.pa.us> 
"Shane R. Spencer"  writes:
> Is there a less string oriented method of converting seconds as an int
> to an interval?

Multiply by an interval, eg

	123456.789 * interval '1 second'

It works, it's fast, and you can use any scale factor you want.

			regards, tom lane
В списке pgsql-general по дате отправления
Предыдущее
От: Shane R. Spencer
Дата:
Следующее
От: Adam Rich
Дата:
FAQ