Re: question about postgresql time intervals

Michael Glaesemann <grzm(at)myrealbox(dot)com> writes:
> On Mar 15, 2006, at 23:39 , Linda wrote:
>> According to the SQL standard, shouldn't this work?
>>
>> select '506:47:04'::interval day to second ;

> No one has implemented this in PostgreSQL yet.

It depends on what you define as "work". 8.1 says

regression=# select '506:47:04'::interval day to second ;
interval
-----------
506:47:04
(1 row)

8.0 and before say

regression=# select '506:47:04'::interval day to second ;
interval
------------------
21 days 02:47:04
(1 row)

because before 8.1 we didn't distinguish intervals of "1 day" and "24 hours"
as being different. But the syntax has been accepted for a long time,
at least back to 7.0.

If there's some specific functionality you're after, you should say what
it is rather than expecting us to guess what you mean.

regards, tom lane