| From: | Ben Chobot <bench(at)silentmedia(dot)com> |
|---|---|
| To: | Allen Chen <rocklob(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Inconsistent time interval formatting |
| Date: | 2011-01-13 18:35:32 |
| Message-ID: | 3764DD52-8F88-48BF-8BFF-EDC6E88810DF@silentmedia.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Jan 13, 2011, at 9:34 AM, Allen Chen wrote:
> Has anyone else out there noticed inconsistencies in how pgsql formats time intervals over 1 day?
>
> For example, I have a query that returns a column of intervals and I get output like this:
>
> 30:30:00
> 1 day 03:02:47
> 1 day 01:38:34
> 26:25:29.50
>
> 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'm running PostgreSQL 8.3.12, but I have seen this in earlier versions I've used too.
I have the same issue on 8.4. Fixing it is low on my task list, but I too would like to know why.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kenneth Buckler | 2011-01-13 18:38:26 | Re: Optimal settings for embedded system running PostgreSQL |
| Previous Message | Pavel Stehule | 2011-01-13 18:25:04 | Re: Record with a field consisting of table rows |