Hitachi

Job Management Partner 1 Version 10 Job Management Partner 1/Performance Management User's Guide


15.4.5 Adjusting the time

Performance data of Performance Management is stored based on GMT by default. To adjust time to local time, add the GMT_ADJUST field.

For example, to adjust the time-stamp value to local time, specify the value as follows:

SELECT PI_TCP_DATETIME+PI_TCP_GMT_ADJUST, ...
FROM PI_TCP WHERE ...