Skip site navigation (1) Skip section navigation (2)

BUG #1993: Adding/subtracting negative time intervals changes time zone of result

From: "Nicholas" <hb(at)pg(dot)x256(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1993: Adding/subtracting negative time intervals changes time zone of result
Date: 2005-10-24 00:26:35
Message-ID: 20051024002635.EA1DDF0DC4@svr2.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
The following bug has been logged online:

Bug reference:      1993
Logged by:          Nicholas
Email address:      hb(at)pg(dot)x256(dot)org
PostgreSQL version: 8.0.3,8.0.4,8.1
Operating system:   Gentoo Linux
Description:        Adding/subtracting negative time intervals changes time
zone of result
Details: 

spatula ~ # psql -U postgres
Welcome to psql 8.1beta1, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

postgres=# SELECT VERSION();
                                                               version
----------------------------------------------------------------------------
----------------------------------------------------------
 PostgreSQL 8.1beta1 on i686-pc-linux-gnu, compiled by GCC
i686-pc-linux-gnu-gcc (GCC) 3.3.6 (Gentoo 3.3.6, ssp-3.3.6-1.0, pie-8.7.8)
(1 row)

postgres=# SELECT NOW()-interval '1 week';
           ?column?
-------------------------------
 2005-10-17 08:52:37.355219+10
(1 row)

postgres=# SELECT NOW()-interval '-1 week';
           ?column?
-------------------------------
 2005-10-31 08:52:39.021583+11
(1 row)

postgres=#

Responses

pgsql-hackers by date

Next:From: Josh BerkusDate: 2005-10-24 02:11:21
Subject: Re: Call for port reports
Previous:From: Andrew DunstanDate: 2005-10-24 00:21:44
Subject: Re: [PATCHES] Win32 CHECK_FOR_INTERRUPTS() performance

pgsql-bugs by date

Next:From: NicholasDate: 2005-10-24 01:03:22
Subject: BUG #1994: Ignore the last bug report; this is a confusing time zone feature, not a bug
Previous:From: Paul AndersonDate: 2005-10-24 00:21:50
Subject: BUG #1992: ODBC error with PostgreSQL Win32 Clients

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group