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

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 Sybase Open Client, the default is based on the database server's time zone.

Can be set for an individual connection, or for PUBLIC. You must have the SET ANY PUBLIC OPTION system privilege to set this option for PUBLIC or for another user or role.

This option is set temporarily.

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.

For information about how this option controls conversion of TIMESTAMP to TIMESTAMP WITH TIME ZONE, see Converting to or from TIMESTAMP WITH TIME ZONE.

• time_zone_adjustment connection property