UTC Time in ClearQuest 7.0.1

UTC Time in ClearQuest 7.0.1

 

Before CQ 7.0.1, time stamp are stored using local time of  the database server. With CQ 7.0.1, time stamp can be stored using Coordinated Universal Time (UTC) so that times always can be compared accurately across time zones.

 

New user databases created with CQ 7.0.1 on feature lever 6 always use UTC to store history dates.

 

To concert history time stamps to UTC for existing databases either at feature lever 5 or 6, you must use the installutil –please setutchistorytimestamps. If you have a MultiSite environment, you must also run the timechange.pl script at each replica to update the data to UTC format

 

2 API in ResultSet object methods

• GetConvertToLocalTime
• SetConvertToLocalTime

 

For detail API usage, pls reference the online help