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 по дате отправления: