Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Database options » Alphabetical list of database options

time_zone_adjustment option

Allows a connection's time zone adjustment to be modified.

Allowed values

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')

Default

0

Scope
  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
Remarks

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.