Conversion settings for time zones

The precise time conversion calculation depends on:

• The value that you select in the Time Zone list. Times are prefixed with either Universal Coordinated Time (UTC), Greenwich Mean Time (GMT), or Time Zone (TZ). The list also includes the None option.

• Whether you selected or cleared the Convert to Local check box.

• Whether this is an internal (either imported or defined in PI AF) or external (linked) table.

  The following table explains how displayed times are determined for each possible combination. The exact options in the Time Zone list are dependent on your operating system.

  Time zone	Convert to local	Internal/external	Behavior
  None		Internal	Fields that contain DateTime data type are automatically adjusted for time zone differences and return local times on the client.
  		External	Fields that contain DateTime data type are assumed to be in the time zone of the PI AF server and are adjusted to the client's local time.
  None		Internal	Fields that contain DateTime data type are not translated. Useful for storing date fields where translation is not desired, such as birth date.
  		External	Fields that contain DateTime data type are not translated. Useful for storing date fields where translation is not desired, such as birth date.
  UTC or GMT		Internal	Fields that contain DateTime data type are adjusted to local times on the client.
  		External	Fields that contain DateTime data type are externally stored as UTC, but adjusted to local time on the client, represented as UTC.
  UTC or GMT		Internal	Fields that contain DateTime data type are always represented as UTC.
  		External	Fields that contain DateTime data type are externally stored as UTC, and left as UTC on the client.
  TZ		Internal	Fields that contain DateTime data type are adjusted for time zone differences and are local time on the client. This combination is not normally needed except when external data is being imported into PI System Explorer.
  		External	Fields that contain DateTime data type are adjusted for time zone differences, and are adjusted to local time on the client, represented as UTC.
  TZ		Internal	Fields that contain DateTime data type are left in the time zone specified. A table lookup data reference adjusts as appropriate; however, other applications may not.
  		External	Fields that contain DateTime data type are left in the original time zone specified, represented as UTC. A table lookup data reference adjusts as appropriate; however, other applications may not.