Time zone (wwTimeZone)

For AVEVA Historianversion 8.0 and later, all history data is stored in Coordinated Universal Time (UTC). The wwTimeZone extension allows you to specify the time zone to be used for the timestamps of the returned data values. The Retrieval subsystem will convert the timestamps to local time in the specified time zone.

The wwTimeZone extension may be assigned any of the values stored in the TimeZone column of the TimeZone table in the Runtime database.

The TimeZone table is repopulated at every system startup from Microsoft operating system registry entries, and will therefore reflect the time zones available from the server operating system, including any new or custom time zones which might be added by operating system service packs or installed software.

The Retrieval subsystem will automatically correct for daylight savings time in the requested time zone. When computing daylight savings and time zone parameters, the settings of the server operating system are used. The Retrieval subsystem does not provide any means for using client-side settings.

If wwTimeZone is not specified, the time zone for retrieval defaults to the time zone of the AVEVA Historian computer.

For example:

SELECT TagName, DateTime, Value, wwTimeZone

FROM History

WHERE TagName IN ('SysTimeHour', 'SysTimeMin')

AND DateTime >= '2001-12-20 0:00'

AND DateTime <= '2001-12-20 0:05'

AND wwRetrievalMode = 'Delta'

AND wwTimeZone = 'W. Europe Standard Time'

The results are: