Re: Hour difference?

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Hour difference?
Дата
Msg-id 20030818190139.GB2816@wolff.to
обсуждение исходный текст
Ответ на Re: Hour difference?  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-general
On Mon, Aug 18, 2003 at 11:19:35 -0700,
  Jonathan Bartlett <johnnyb@eskimo.com> wrote:
> Is there a way to get an interval in a standard format?  It seems like it
> keeps changing it's ouput style based on the time length.

Extracting epoch from an interval will return the length in seconds.
(With months treated as having 30 days and years as having 12 months.
But that shouldn't matter for your application.) You can then make
calculations with that number to produce whatever output format you want.

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

Предыдущее
От: Dev
Дата:
Сообщение: Default Value in Table Setup Help
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Why lower's not accept an AS declaration ?