Skip to content

postgres timestamp decoding loses the associated time zone #1265

@lovasoa

Description

@lovasoa

Postgres timestamp decoding loses the associated time zone and returns a string that represents a different time.

set x = '2021-01-01T02:00+02:00'::timestamptz;
select 'debug' as component, $x as x;

Actual behavior

{"component":"debug","x":"2021-01-01T01:00:00+00:00"}

Expected behavior

{"component":"debug","x":"2021-01-01T02:00:00+02:00"}

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions