Specifies which time zone the database uses for time zone calculations.
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').
|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.