I have an application generating an expiration timestamp. I had some problems, so I debugged around a bit and it confuses me more and more.
I use this example:
SELECT TIMESTAMP '2013-08-13 00:00:00' AT TIME ZONE 'UTC'
When I run this in Navicat, I get back
timezone
----------------------
2013-08-12 22:00:00+00
When I run this code in DBeaver, I get back
timezone
-------------------
2013-08-13 02:00:00
It is the same DB, the same user, the same schema, the only difference is the client programm from which I call this example. Where does the difference between the results come from?