Message-ID: <492766DF.2050902@cheapcomplexdevices.com>
Date: Fri, 21 Nov 2008 17:56:47 -0800
From: Ron Mayer <rm_pg@cheapcomplexdevices.com>
User-Agent: Thunderbird 2.0.0.17 (X11/20080925)
MIME-Version: 1.0
To: Zagato <zagato.gekko@gmail.com>
CC: pgsql-general@postgresql.org
Subject: Re: Interval Format
References: <98028b00811211739qb4a5e6bqf478bee397ea3596@mail.gmail.com>
In-Reply-To: <98028b00811211739qb4a5e6bqf478bee397ea3596@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Zagato wrote:
> I have som SQL that in 8.0.3 do:
> # SELECT '32 hours'::INTERVAL;
>     interval
> -----------------
>  @ 1 day 8 hours
> 
> And in 8.3.5 do:
> seg_veh2=# SELECT '@ 32 hours'::INTERVAL;
>   interval
> ------------
>  @ 32 hours
> 
> Why i unable to get my old style of interval, i really need to see the 
> day part.... im using datestyle german in both.... im try with "SET 
> IntervalStyle TO..." but i get this error:

Even IntervalStyle won't help you here; since recent releases consider
the values "1 day 8 hours" as distinct from "32 hours" (because
they are at certain times of the year in some timezones
where days are 25 hours, etc).

> So.. how can i recover my "days" part...

If you tell it what time of year you are thinking of this trick can work:

dish=# set datestyle to german;
SET
dish=# select  '2001-01-01'::timestamp + (interval '32 hours') - '2001-01-01'::timestamp;
     ?column?
-----------------
  @ 1 day 8 hours
(1 row)


> 
> Any help it appreciate... thanks :D