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 database 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