Time Stamp fields

The command format is:
SELECT(PERFORMANCE|EXCEPTION|LOGGER(
       INCLUDE|EXCLUDE(
       START|STOP|ACTIVE(FROM(date,time),TO(date,time)),...),...))

Three time stamp fields can be specified with the SELECT(PERFORMANCE and SELECT(EXCEPTION operands:

START
Refers to when the transaction was attached or when processing continued from a conversational transaction.
STOP
Refers to when the transaction was detached or a conversational transaction waited for terminal input.
ACTIVE
Refers to the entire time span between the Start and Stop times. ACTIVE can be used to make sure long-running transactions are included when their Start or Stop times fall out of the selection range.

Only the STOP time stamp field can be specified with the SELECT(LOGGER operand.

FROM and TO together specify the report interval, and represent either a date/time range or a time slot (times only). The operands are positional, with FROM preceding TO. Up to 14 report intervals can be specified.

The date is either a calendar date in the format yyyy/mm/dd or a relative date. Relative dates are specified as 0, -1, -2,... to signify a date relative to the current date. 0 represents today, -1 yesterday, -2 two days ago, and so on. If both FROM and TO dates are specified, they must be in the same format.

The time is a time-of-day in the format hh:mm:ss.th.

For a date/time range:
  • Either FROM or TO can be omitted to indicate that the range is open-ended. If FROM is omitted, it defaults to the first input record. If TO is omitted, it defaults to the end of file.
  • If the FROM date is specified with no time, a time of zero is assumed (start of day)
  • If the TO date is specified with no time, a time of 23:59:59.99 is assumed (end of day).

For a time slot, both times must be specified with no dates to signify the same time slot every day. The times can span midnight.

For example, the following command includes performance records for transactions running between 8:00 in the morning and 6:00 in the evening:
SELECT(PERFORMANCE(INCLUDE(ACTIVE(FROM(08:00),TO(18:00)))))
To specify both date and time, the format is:
  • Calendar date: FROM(yyyy/mm/dd,hh:mm:ss.th)
  • Relative date: FROM(-n,hh:mm:ss.th)
To specify a date only, the format is:
  • Calendar date: FROM(yyyy/mm/dd,)
  • Relative date: FROM(-n,)
Note: The comma following the date is required to designate the missing time value.

To specify a time only, the format is FROM(,hh:mm:ss.th) or FROM(hh:mm:ss.th). The comma preceding the time is optional.

For further information on specifying date and time values, see Operand value formats.