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

SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » Configuring Your Database » Database options » Introduction to database options » Alphabetical list of options


time_zone_adjustment option [database]

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

Allowed values

Integer (for example, 300)

Negative integer enclosed in quotation marks (for example, '-300')

String representing a time in hours and minutes, preceded by + or - and enclosed in quotation marks (for example, '+5:00', or '-5:00')


If the client is connecting via embedded SQL, ODBC, OLE DB, ADO, or ADO.NET, the default value is set according to the client's time zone. If the client is connecting via jConnect or Open Client, the default is based on the database server's time zone.


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.

See also