PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15388
PG Version10.1
OSlinux
Opened2018-09-18 03:22:34+00
Reported byhao.hu
StatusOpen

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15388
Logged by:          hao.hu
Email address:      (redacted)
PostgreSQL version: 10.1
Operating system:   linux
Description:        

1. What did you do?
SET TIME ZONE 'utc';
SELECT TIMESTAMP '2001-02-16 20:38:40' AT TIME ZONE '+8';

2. What did you expect to see?
        timezone
------------------------
 2001-02-16 12:38:40+00

3. What did you see instead?
        timezone
------------------------
 2001-02-17 04:38:40+00

Messages

DateAuthorSubject
2018-09-18 03:22:34+00=?utf-8?q?PG_Bug_reporting_form?=BUG #15388: time convert error when use AT TIME ZONE '+8'
2018-09-18 03:45:05+00Tom LaneRe: BUG #15388: time convert error when use AT TIME ZONE '+8'
2018-09-18 16:36:53+00"Peter J(dot) Holzer"Re: BUG #15388: time convert error when use AT TIME ZONE '+8'
2018-09-18 18:27:50+00Tom LaneRe: BUG #15388: time convert error when use AT TIME ZONE '+8'