Default language.

Space announcement The Using section of the MainView for DB2 documentation is now available in Japanese. The displayed language is dependent on your browser language. You can switch languages from the Language menu.

Valid date formats for the START and END keywords

The valid date formats for the START and END keywords are as follows:

Date format

Description

USA format

You can specify the date in one of the following formats:

  • mm/dd/yyyy
  • mm/dd/yy
  • mm/dd

European format

You can specify the date in one of the following formats:

  • dd/mm/yyyy
  • dd/mm/yy
  • dd/mm

ISO format

You can specify the date in one of the following formats:

  • yyyy/mm/dd
  • yy/mm/dd

Note

You must specify the year if using the ISO format.

Consider the following points when specifying a date and time:

  • You can specify the year in a two-digit or four-digit format.
  • If you specify the year as two digits, Data Collector interprets 00-36 as 2000-2036, and 81-99 as 1981-1999. Values 37-80 are invalid.
  • If you specify a date without yy or yyyy, the year defaults to the current year (USA and European formats only).
  • You can specify the date format by preceding the date with one of the following characters:
    • U (USA format)
      This is the default format. If you do not precede the date with a character, the interval uses the USA date format. 
    • E (European format)
    • I (ISO format)
  • You can specify time by using one of the following formats:
    • hh:mm:ss (hours, minutes, and seconds)
    • hh:mm (hours and minutes)
Example

The following example uses a USA format to request a reporting interval from July 1, 2016 at 10 P.M. to July 31, 2016 at 10 P.M.:

INTERVAL(START(U07/01/16,22:00),END(U07/31/16,22:00)

The following example uses a European format to specify the same interval:

INTERVAL(START(E01/07/16,22:00),END(E31/07/16,22:00)



 

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