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.