PostgreSQL timestamptz not behaving correctly

Note: please leave bug reports and feature requests on

PostgreSQL timestamptz not behaving correctly

Postby james.wheeler.pe » Fri Jun 13, 2014 2:02 pm

set session time zone '0';

select mfgOperationID, completionDateTime, startDateTime, entryDateTime, entryDateTime-completionDateTime
from temp_mfgOperations where mfgOperationID = 39068411
order by entryDateTime desc;


What should happen and does happen with other tools like pgAdmin III is that I see the time columns rendered as if I were in the GMT timezone.

What happens with DBeaver is that I always see the time columns rendered based on the timezone of the machine running DBeaver.

For example I should get back 2014-06-12 01:00:00 but instead I am getting 2014-06-11 21:00:00.
james.wheeler.pe
 
Posts: 3
Joined: Thu Jun 12, 2014 6:26 pm

Re: PostgreSQL timestamptz not behaving correctly

Postby ezidore » Thu Jan 07, 2016 3:04 pm

I got the same issue.
The time sone set during a session with DBeaver doesn't affect rendering of a timestamptz (contrary to the "standard" client psql).
ezidore
 
Posts: 1
Joined: Thu Jan 07, 2016 2:56 pm


Return to Support



Who is online

Users browsing this forum: Google [Bot] and 5 guests

cron