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

Default

Empty string

Scope

	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

Remarks

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.