Re: Inconsistent time interval formatting

Поиск
Список
Период
Сортировка
От Gary Chambers
Тема Re: Inconsistent time interval formatting
Дата
Msg-id alpine.OSX.2.01.1101131341130.38157@localhost
обсуждение исходный текст
Ответ на Re: Inconsistent time interval formatting  (Ben Chobot <bench@silentmedia.com>)
Ответы Re: Inconsistent time interval formatting
Список pgsql-general
>> Why do some of the intervals show days broken out whereas others only
>> show hours?   I have seen intervals left in hours even when the intervals
>> are more than two days long.  FWIW, I would prefer if it was always left
>> in hours, but would be happy if it would just be consistent either way.

> I have the same issue on 8.4. Fixing it is low on my task list, but I too
> would like to know why.

An interim fix might be to cast your output to interval(0) (or to whatever
degree of precision you might need).  I believe I encountered this behavior
some time ago and casting solved the problem for me.

-- Gary Chambers

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

Предыдущее
От: Kenneth Buckler
Дата:
Сообщение: Re: Optimal settings for embedded system running PostgreSQL
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Inconsistent time interval formatting