Re: BUG #12326: I think maybe postgresql has a problem about timezone. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #12326: I think maybe postgresql has a problem about timezone.
Date
Msg-id 6076.1419433918@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #12326: I think maybe postgresql has a problem about timezone.  (张亚琪 <zhangyingyun001@gmail.com>)
Responses Re: BUG #12326: I think maybe postgresql has a problem about timezone.
List pgsql-bugs
张亚琪 <zhangyingyun001@gmail.com> writes:
> show timezone;
> TimeZone
> ----------
>  PRC
> (1 row)

> # update history_configuration set var_datetime = 'Wed Dec 24 18:52:46 CST
>> 2014' where var_name = 'lastHourAggr';

> # select * from history_configuration ;
>      var_name      | var_value |      var_datetime
> -------------------+-----------+------------------------
>  lastHourAggr      |           | 2014-12-25 08:52:46+08

As John says, this behavior is perfectly expected because Postgres thinks
"CST" means US Central Standard Time (GMT-6, currently).

If you want CST to mean China Standard Time, you'll need to set up a
custom zone abbreviation file.  See
http://www.postgresql.org/docs/9.3/static/datetime-config-files.html

For some reason this interpretation of "CST" got missed out when preparing
the sample data in Asia.txt, but I think what you need is just

@INCLUDE Default
@OVERRIDE
CST  28800
        regards, tom lane



pgsql-bugs by date:

Previous
From: Jeff Janes
Date:
Subject: Re: BUG #12326: I think maybe postgresql has a problem about timezone.
Next
From: Tom Lane
Date:
Subject: Re: BUG #12292: index row size 1480 exceeds maximum 1352 for index