System date times

The CIS software components store system dates and timestamps as follows:

Software component	Storage of system dates and timestamps
InForm software	Stored as Universal Time (also called Greenwich Mean Time) (UTC or GMT) and displayed according to the time zone of the user site.
CIS software	Stored as UTC/GMT.
Clintrial software	Stored as local time on the Oracle machine. In Clintrial audit tables, the ENTRY_DATETIME column reflects the time the record was updated in InForm software (in UTC/GMT), and the MERGE_DATETIME column reflects the time the value was updated in the Clintrial software (in the local time of the Clintrial machine).

Software component

Storage of system dates and timestamps

InForm software

Stored as Universal Time (also called Greenwich Mean Time) (UTC or GMT) and displayed according to the time zone of the user site.

CIS software

Stored as UTC/GMT.

Clintrial software

Stored as local time on the Oracle machine.

In Clintrial audit tables, the ENTRY_DATETIME column reflects the time the record was updated in InForm software (in UTC/GMT), and the MERGE_DATETIME column reflects the time the value was updated in the Clintrial software (in the local time of the Clintrial machine).

Because the InForm and CIS machines store the same system dates and timestamps, there is no need for the machines to be set to the same time zone as long as their system clocks are synchronized. You should set the Clintrial machine to the time zone you want to use for analyzing data; UTC/GMT is suggested to minimize confusion.