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 option

Specifies which time zone the database uses for time zone calculations.

Allowed values

String identifying an existing time zone that was created using the CREATE TIME ZONE statement.

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


Empty string

  PUBLIC role For current user For other users
Allowed to set permanently? Yes, with MANAGE TIME ZONE No No
Allowed to set temporarily? Yes, with MANAGE TIME ZONE No No

Setting this option causes the database to act like it is running in the specified time zone. This database option affects calculations that use the CURRENT TIME special value or the NOW or GETDATE functions, but does not affect the value of the CURRENT UTC TIME or CURRENT SERVER TIME special value.

You can also set this option to an offset (number of minutes or hours:minutes) for the database to use an un-named time zone with the specific offset and no daylight savings time.

Note To specify a string that identifies the time zone, first populate the ISYSTIMEZONE table with that time zone. To populate ISYSTIMEZONE, execute either the CREATE TIME ZONE or ALTER TIME ZONE statement.