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:
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 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)))))
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.