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

Bug #695: Wrong Timezone offset (like bug#672)

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #695: Wrong Timezone offset (like bug#672)
Date: 2002-06-24 07:33:39
Message-ID: 20020624073339.19B1F475C1E@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
N. Fung (php-jp(at)typhoon(dot)co(dot)jp) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
Wrong Timezone offset (like bug#672)

Long Description
function datetime() and extract() returns wrong timezone offset values.  This is present in v7.2.1 but NOT in v7.0.3:

In v7.0.3:

% perl -le 'print time ;'
1024903188
% psql template1
Welcome to psql, the PostgreSQL interactive terminal.

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

template1=# select datetime(1024903188) \g
       timestamp        
------------------------
 2002-06-24 16:19:48+09
(1 row)

template1-# \q
% date
Mon Jun 24 16:20:17 JST 2002

In v7.2.1:

perl -le 'print time'
1024903424
% psql template1
Welcome to psql, the PostgreSQL interactive terminal.

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

template1=# select datetime(1024903424) \g
      timestamp      
---------------------
 2002-06-23 22:23:44
(1 row)

template1=# \q
% date
Mon Jun 24 16:24:12 JST 2002

% psql template1
Welcome to psql, the PostgreSQL interactive terminal.

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

template1=# select now() \g
             now
------------------------------
 2002-06-24 16:30:09.99867+09
(1 row)

template1=# select extract(timezone_hour from now()) \g
 date_part
-----------
        -9
(1 row)

---

Although I am in JST (UTC+9) postgresql is telling me the I'm UTC-9.

--end of report---



Sample Code


No file was uploaded with this report




Responses

pgsql-bugs by date

Next:From: Ruslan A DautkhanovDate: 2002-06-24 09:19:56
Subject: get last OID
Previous:From: Peter EisentrautDate: 2002-06-23 21:49:55
Subject: Re: [PATCHES] pg_dumpall should permit quiet operation

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