Time Data

All time data is exported as seconds without any formatting.

For example, if the report shows a time of 1:30:10 (one hour, 30 minutes, and 10 seconds) the export file will contain the value 5410 seconds. This is 3600 seconds in one hour, plus 1800 seconds in 30 minutes, plus 10 seconds = 5410 total seconds.

Usually the CMS report shows rounded numbers. The exported report data will not round the number of seconds. Thus the exported data will almost always have some decimal numbers. In the given example, the exported number may be 5410.123.

STARTTIME appears in interval data (and is used in interval reports to show the start and end of the interval e.g. 1:30 – 2:00AM). This uses special formatting to display correctly however if Export Time Durations in Seconds is chosen the raw data STARTTIME ‘-’ STARTTIME+INTRVL will be exported. Eg: 130 – 160 would be shown if the interval length is 30 minutes. The Supervisor PC client doesn’t export these raw values when Export Time Durations in Seconds is selected and instead exports the formatted values.

Dates

Dates are exported as retrieved from the database without any formatting applied.

Dates that look like 44413 are Informix time and date format , which is the number of days since December 31, 1899.

Dates that look like 1628284958 are in Unix Epoch time and date format which is seconds since January 1, 1970 UTC not counting leap seconds.

The dates in CMS that are stored in Informix time/date format are:

• ROW_DATE

  • ROW_DATE is an index field that appears in many CMS tables. Every occurrence of ROW_DATE in every table will be in Informx time/date format.

• In the customer_log table, the date_occurred field

• In the f_cday table, the hdate1, hdate2, hdate3 hdate2 and trenddate fields

• In the haglog table, the logout_date field

• All other dates in CMS are in Unix Epoch time.