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

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Database Options » Introduction to database options » Alphabetical list of options

time_format option [compatibility] Next Page

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

Default

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 server's time zone.

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.

See also