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

From Tom Lane
Subject Re: BUG #1993: Adding/subtracting negative time intervals
Date
Msg-id 8993.1130210512@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #1993: Adding/subtracting negative time intervals  (Klint Gore <kg@kgb.une.edu.au>)
Responses Re: BUG #1993: Adding/subtracting negative time intervals
List pgsql-bugs
Klint Gore <kg@kgb.une.edu.au> writes:
> That's changed since v7.4.7

Yup.  '1 week' = '7 days' which is no longer the same as 7*24 hours.
In particular, as of 8.1 local noon plus one day is still local noon,
even if there was a DST change in between.  Adding 24 hours, on the
other hand, might give 11am or 1pm.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Klint Gore
Date:
Subject: Re: BUG #1993: Adding/subtracting negative time intervals
Next
From: Michael Fuhr
Date:
Subject: Re: BUG #1993: Adding/subtracting negative time intervals