Time Zone Configuration

The TIMEZONE parameter in the CES_PARAMETERS database table specifies the name of the time zone used by NMS backend services and database.

This parameter is used by the PK_CCB PL/SQL package to convert input data to the correct timezone for storing in the NMS database and to add timezone information to output data.

A list of the time zone region names known to the database can be obtained from the V$TIMEZONE_NAME dynamic performance view. Time zone region name should be used instead of a simple offset to ensure that Daylight Savings Time is accounted for.

Example

INSERT INTO CES_PARAMETERS (APP, ATTRIB, VALUE) VALUES

('NMS', 'TIMEZONE', 'America/Chicago');