Re: Inconsistent time interval formatting

Поиск
Список
Период
Сортировка
Искать
От
Ben Chobot
Тема
Re: Inconsistent time interval formatting
Дата
Msg-id
D448F91F-8F36-4FA2-8495-0A592E33FA99@silentmedia.com
Ответ на
Список
Дерево обсуждения
Inconsistent time interval formatting Allen Chen <rocklob@gmail.com>
Re: Inconsistent time interval formatting Ben Chobot <bench@silentmedia.com>
Re: Inconsistent time interval formatting Gary Chambers <gwchamb@gwcmail.com>
Re: Inconsistent time interval formatting Tom Lane <tgl@sss.pgh.pa.us>
Re: Inconsistent time interval formatting Ben Chobot <bench@silentmedia.com>
Re: Inconsistent time interval formatting John R Pierce <pierce@hogranch.com>
Re: Inconsistent time interval formatting Ben Chobot <bench@silentmedia.com>
Re: Inconsistent time interval formatting Allen Chen <rocklob@gmail.com>
Re: Inconsistent time interval formatting Tom Lane <tgl@sss.pgh.pa.us>
Re: Inconsistent time interval formatting Adrian Klaver <adrian.klaver@gmail.com>
Re: Inconsistent time interval formatting John R Pierce <pierce@hogranch.com>
On Jan 13, 2011, at 1:15 PM, John R Pierce wrote:

> On 01/13/11 1:08 PM, Ben Chobot wrote:
>> On Jan 13, 2011, at 11:03 AM, Tom Lane wrote:
>> 
>>> If you don't care about that, you can use justify_hours (I think that's
>>> the right function) to smash them to the same thing.
>> I use justify_hours, and I still get entries like '1 day 35:31:10' intermixed with the entires I'd expect like '2 days 03:12:40'.

Ho ho... for the record, it turns out that the one column in our report which has these issues is the one somebody forgot got wrap with justify_hours. 
В списке pgsql-general по дате отправления
От: Adrian Klaver
Дата:
От: Dan Birken
Дата:
FAQ