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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-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=#
From | Date | Subject | |
---|---|---|---|
Next Message | Nicholas | 2005-10-24 01:03:22 | BUG #1994: Ignore the last bug report; this is a confusing time zone feature, not a bug |
Previous Message | Paul Anderson | 2005-10-24 00:21:50 | BUG #1992: ODBC error with PostgreSQL Win32 Clients |
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2005-10-24 02:11:21 | Re: Call for port reports |
Previous Message | Andrew Dunstan | 2005-10-24 00:21:44 | Re: [PATCHES] Win32 CHECK_FOR_INTERRUPTS() performance |