Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Ops Monitor for CMF 6.3.

DATETIME

The DATETIME control statement defines the overall date and time range for the data you want to use in your reports.

DATETIME (sdate[:stime],edate[:etime])

A record is selected for a report only if the date and time of the start of its recording interval falls within the specified DATETIME range. To clarify, if you define DATETIME as the following, any SMF record whosestart-of-interval date and time falls between 8:00:00 A.M. of March 22, 2008 through midnight of March 23, 2008, is selected for processing.

DATETIME (22MAR2008:080000,23MAR2008:240000)

Note that the data collection (or extraction) interval affects how reports are produced. For example, if REPORT CPM,SYNCH=59, INTERVAL=30 was specified when starting the CMF MONITOR Extractor, records will exist which have a start-of-interval time before 8:00 A.M. Thus, using the above DATETIME statement, these records will not be selected even though most of their data was gathered after 8:00 A.M.

A specific report time range can be smaller because there are other control statements, such as the CYCLE, SHIFT, and PERIOD statements that divide the overall DATETIME range into smaller ranges of time. When applied to a report control statement, the report is modified to include only data that falls between the defined period.

When using this statement, both a begin date-time and an end date-time must be specified.

Parameters

The parameters for the DATETIME control statement are as follows:

sdate

specifies the start date for the report data range

This parameter is required for the DATETIME statement. This parameter is expressed in one of the following three formats:

  • Julian—yyddd or yyyyddd, where
    • yy—The year can be represented as two digits. Two-digit years represent years in the range 1950-2049. Example: January 1, 2006 can be represented as 06001.
    • yyyy—The year can be represented as four digits. Example: January 1, 2006 can be represented as 2006001.
    • ddd—The number of days into the year can be represented as three digits and can be a value from 1 to 365 (366 during leap years).
  • Gregorian—ddmmmyy or ddmmmyyyy where

    • dd represents the date of the month; must be a value between 1 and 31

      (You are not required to insert a leading zero for values lower than 10.)

    • mmm represents the month as three alphabetic characters

      The acceptable values are:

      • JAN
      • FEB
      • MAR
      • APR
      • MAY
      • JUN
      • JUL
      • AUG
      • SEP
      • OCT
      • NOV
      • DEC

    • yyyy represents the year as four digits

      Example: January 1, 2006 can be represented as 01JAN2006.

    • yy represents the year as two digits

      A value in the range 00-49 represents a year in the range 2000-2049. Example: January 1, 2006 can be represented as 01JAN06.

  • Relative—*{- nnn}: where

    • * indicates today; if specified by itself without an - nnn value, the date specified is today

      When an asterisk is used, the DATETIME card reads the current date from your system time.

    • [- nnn] (optional) indicates the number of days prior to today’s date where the report data should start

      For example, *-7 means the DATETIME range is today minus 7 days, or the date exactly one week ago.

stime

specifies the start time for the DATETIME range start date

Specifying stime is optional. The time is based on a 24-hour clock. This parameter is expressed as hhmmss{.th} where

  • hh— number of hours; acceptable values are 00 to 24
  • mm—number of minutes; acceptable values are 00 to 59
  • ss—number of seconds; acceptable values are 00 to 59

  • th—hundredths of seconds; acceptable values are 00 to 99

    Specifying a hundredths value is optional. If specified, a period (.) must separate this value from the ss value, if defined.

Note

If stime is not defined, the default value of midnight (000000) is used.

A colon (:) must precede the time value, separating it from the date value.

edate

specifies the end date for the DATETIME range

This parameter is required and must be expressed in the same format as the sdate parameter.

etime

specifies the end time for the DATETIME range end date

The end time is optionally defined. The same format used to define the optional stime parameter is used to define this parameter.

Note

A colon (:) must precede the time value, separating it from the date value.

Syntax rules for the DATETIME statement

Syntax rules for the DATETIME statement are as follows:

  • If a time value is specified, a colon (:) must precede the time value, separating it from the date value.
  • A comma must separate the start and end dates.

  • The relative format is useful for running reports on a consistent basis because the dates defining the DATETIME range need not change each time the reports run.

    For example, if a site requires weekly reports to be produced each Monday, *-7 as the start range date and * as the end range date could be defined once; otherwise, the Julian day or Gregorian day or month values must be changed each week to obtain the current data.

  • If the CYCLE or PERIOD statement is used, a DATETIME control statement must be used (see the table that shows permitted values for the cycle name parameter in CYCLE, and PERIOD for additional information). The order of these statements must be
    1. DATETIME
    2. CYCLE
    3. PERIOD

Note

If these commands are entered out of this sequence, a control statement error results.

Examples

The following examples illustrate the use of the DATETIME control statement.

Example
DATETIME  (20OCT2008:100000,20OCT2008:110000)

This example specifies the date-time range on October 20th, 2008 from 10:00 A.M. to 11:00 A.M.


Example


DATETIME  (*-1:080000,*:080000)

This example specifies the date-time range from 08:00 A.M. yesterday to 08:00 A.M. today.


Example


DATETIME  (*,*:120000)

This example shows a date-time range from 00:00 to noon today.


Example


DATETIME  (01JUN10,02JUN10)

This example shows a date-time range from midnight (00:00:00) of June 1, 2010 to midnight of 2 June, 2010. 

Related topics

DEVICE-Extractor-control-statements

General control statements


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*