Allows a connection's time zone adjustment to be modified.
Unsigned integer (for example, 300)
A positive or negative signed integer enclosed in quotation marks (for example, '+300' or '-300')
String representing a time in hours and minutes, preceded by + or - and enclosed in quotation marks (for example, '+5:00', or '-5:00')
0
PUBLIC role | For current user | For other users | |
---|---|---|---|
Allowed to set permanently? | No | No | No |
Allowed to set temporarily? | Yes, with SET ANY PUBLIC OPTION | Yes (current connection only) | No |
The time_zone_adjustment option value is the same value as that returned by SELECT CONNECTION_PROPERTY( 'TimeZoneAdjustment' ). The value represents the number of minutes that must be added to the Coordinated Universal Time (UTC) to display time local to the connection.