Re: BUG #1993: Adding/subtracting negative time intervals - Mailing list pgsql-bugs

From Klint Gore
Subject Re: BUG #1993: Adding/subtracting negative time intervals
Date
Msg-id 435F060A26C.2D9BKG@129.180.47.120
Whole thread Raw
In response to Re: BUG #1993: Adding/subtracting negative time intervals  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: BUG #1993: Adding/subtracting negative time intervals
Re: BUG #1993: Adding/subtracting negative time intervals
List pgsql-bugs
[sorry about the previous email, I quoted the wrong bit and clicked the
wrong button]

On Tue, 25 Oct 2005 23:41:54 -0400 (EDT), Bruce Momjian
<pgman@candle.pha.pa.us> wrote:
>     test=> select
>     test-> ('2005-10-30 13:22:00-05'::timestamptz -
>     test(>  '2005-10-29 13:22:00-04'::timestamptz);
>      ?column?
>     ----------
>      25:00:00
>     (1 row)

Is that actually the correct answer?

Disregarding daylight savings, there is 25hrs between them.  Once
daylight savings is taken into account there should be 24 or 26 hours
between them (southern/northern hemisphere respectively).

Or have I missed something obvious?

klint.

+---------------------------------------+-----------------+
: Klint Gore                            : "Non rhyming    :
: EMail   : kg@kgb.une.edu.au           :  slang - the    :
: Snail   : A.B.R.I.                    :  possibilities  :
: Mail      University of New England   :  are useless"   :
:           Armidale NSW 2351 Australia :     L.J.J.      :
: Fax     : +61 2 6772 5376             :                 :
+---------------------------------------+-----------------+

pgsql-bugs by date:

Previous
From: Klint Gore
Date:
Subject: Re: BUG #1993: Adding/subtracting negative time intervals
Next
From: John R Pierce
Date:
Subject: Re: BUG #1993: Adding/subtracting negative time intervals