I'm in a UTC+03:00 time zone.
When I change the time zone on my computer to UTC+08:00 (and reboot the dbsrv12), I get the following
Therefore, does not work correctly TimeZoneAdjustment?
What computer are you using to connect to the server? My guess is that it is a different computer than the one where the server is running.
The connection property returns the time zone adjustment value for the client - it does this by using the timezone data which is passed from the client to the server. Therefore CONNECTION_PROPERTY('TimeZoneAdjustment') will remain at 180 (3 hours) if you did not change the timezone of the computer from which you are connecting.
The datediff computation is correct because on the server the difference is eight hours = 480 minutes.
Note that this documentation page states that the TimeZoneAdjustment connection property:
So it appears that the software is working as expected.
answered 17 Apr '13, 18:22