Contents Index TIME_FORMAT option [compatibility] TIMESTAMP_FORMAT option [compatibility]

ASA Database Administration Guide
  Database Options
    Alphabetical list of options

TIME_ZONE_ADJUSTMENT option [database]


Function 

Allows a connection's time zone adjustment to be modified.

Allowed values 

Integer, (for example, 300), or

Negative integer, enclosed in quotation marks (for example, '-300'), or

String, representing a time in hours and minutes, preceded by + or -, enclosed in quotation marks (for example, '+5:00', or '-5:00').

Default 

If the client is connecting via ESQL, ODBC, OLE DB, or ADO, the default value is set according to the client's time zone. If the client is connecting via jConnect or OpenClient, the default is based on the server's time zone.

See also 

Connection-level properties

Description 

The TIME_ZONE_ADJUSTMENT option value is the same value as that returned by 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.


Contents Index TIME_FORMAT option [compatibility] TIMESTAMP_FORMAT option [compatibility]