Time Stamp fields
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.
- 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.
SELECT(PERFORMANCE(INCLUDE(ACTIVE(FROM(08:00),TO(18:00)))))
- Calendar date: FROM(yyyy/mm/dd,hh:mm:ss.th)
- Relative date: FROM(-n,hh:mm:ss.th)
- Calendar date: FROM(yyyy/mm/dd,)
- Relative date: FROM(-n,)
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.