On Tue, Mar 12, 2013 at 3:11 PM, Michael Paquier <[email protected]>wrote:
> postgres=# select extract(day from ((CAST(-3 || 'day' as interval)+now()) > - now())); > date_part > ----------- > -2 > (1 row) > Here I believe that the correct result should be -3. > Note that it passes with values upper than -2 and lower than -127: > Also note that this happens only with the timezone set where time -1day. > Sorry for the noise, I found the same question answered here: http://www.postgresql.org/message-id/[email protected] This is due to the fact that US/Pacific moved to DST last weekend. -- Michael
