Re: question about postgresql time intervals

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: lgray(at)unitrends(dot)com
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: question about postgresql time intervals
Date: 2006-03-16 00:25:06
Message-ID: 7BF4399A-4004-4D80-ABFD-2F1DCD1DC289@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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.

> Is there a portable way to do this without using justify_hours()?

Not currently that I know of.

Michael Glaesemann
grzm myrealbox com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2006-03-16 00:33:38 Re: tsearch is slow
Previous Message Abbath 2006-03-16 00:09:19 Re: tsearch is slow