Re: Problem with intervals - Mailing list pgsql-sql

From Bob Smith
Subject Re: Problem with intervals
Date
Msg-id E6FD177F-2509-11D8-8F43-0003933DD370@h-e.com
Whole thread Raw
In response to Re: Problem with intervals  ("Alexander M. Pravking" <fduch@antar.bryansk.ru>)
List pgsql-sql
On Tuesday, Dec 2, 2003, at 03:53 US/Pacific, Alexander M. Pravking 
wrote:

> On Mon, Dec 01, 2003 at 09:09:20PM -0800, Bob Smith wrote:
>> I'm getting an unexpected result using intervals in an expression:
>>
>> select ('2003-10-26 0:00:00'::timestamp + '1 day'::interval)::date;
>>     date
>> ------------
>>  2003-10-26
>> (1 row)
>
> Try using '2003-10-26 0:00:00'::date + 1;
> integers do not lie ;-)

Aha!  That solves my problem for now.  I had also discovered that using 
'25 hours'::interval works, but the integer approach is better.

> It has been discussed several times, Tom Lane offered to add 'day' as
> a separate interval unit (like 'second' and 'month' at this moment),
> but noone took a shot at it, AFAIK.
>
>
> Note also, that in 7.3 "timestamp" means "timestamp without time zone",
> while in 7.2 it's "timestamp with time zone".

Yet another reason to upgrade, I guess I'm gonna have to do it soon...

Thanks for your help!

Bob S.



pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Validity check in to_date?
Next
From: Alvar Freude
Date:
Subject: [postgres] Text zu bytea casten