Specifying a time period

In Prompted Query, you can specify a period of time from which data is retrieved for your report. You can specify the time period as an application period (BUSINESS_TIME) or a system period (SYSTEM_TIME).

About this task

You can specify a time period for a temporal table or for a view. However, if you specify a time period for a view that does not reference a temporal table, the time period specification is ignored.

Procedure

To specify a time period:

  1. On the Specify panel, select Time Period.
  2. From the list of eligible tables and views, select a table or view for which you will specify a time period.
  3. Enter the time period specification in one of the following formats, and then press Enter:
    • FOR BUSINESS_TIME AS OF 'yyyy-mo-dd'
    • FOR BUSINESS_TIME FROM 'yyyy-mo-dd' TO 'yyyy-mo-dd'
    • FOR BUSINESS_TIME BETWEEN 'yyyy-mo-dd' AND 'yyyy-mo-dd'
    • FOR SYSTEM_TIME AS OF 'yyyy-mo-dd-hh.mm.ss.nn'
    • FOR SYSTEM_TIME FROM 'yyyy-mo-dd-hh.mm.ss.nn' TO 'yyyy-mo-dd-hh.mm.ss.nn'
    • FOR SYSTEM_TIME BETWEEN 'yyyy-mo-dd-hh.mm.ss.nn' AND 'yyyy-mo-dd-hh.mm.ss.nn'
    where:
    • yyyy is a four-digit value that represents the year.
    • mo is a two-digit value that represents the month.
    • dd is a two-digit value that represents the day.
    • hh is a two-digit value that represents the hour.
    • mm is a two-digit value that represents the minutes.
    • ss is a two-digit value that represents the seconds.
    • nn is a 0- through 12-digit value that represents the number of fractional seconds.