Re: Inconsistent time interval formatting

From: Gary Chambers <gwchamb(at)gwcmail(dot)com>
To: Ben Chobot <bench(at)silentmedia(dot)com>
Cc: Allen Chen <rocklob(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Inconsistent time interval formatting
Date: 2011-01-13 18:45:45
Message-ID: alpine.OSX.2.01.1101131341130.38157@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2011-01-13 18:48:13 Re: Inconsistent time interval formatting
Previous Message Kenneth Buckler 2011-01-13 18:38:26 Re: Optimal settings for embedded system running PostgreSQL