Time stamp format


Message Advisor time stamps conform to the Data Base Recovery Control (DBRC) method. The time stamp syntax is ‘.yyyy.ddd.hh.mm.ss.t.<offset>’. Consider the following when specifying time stamps:

  • You can remove each ‘.’, or you can replace each ‘.’ with a delimiter. You can use any character except ‘+’, ‘-’, a quote, alphanumeric characters, or national characters as the delimiter.
  • If a time stamp includes blanks or commas as delimiters, you must enclose the entire time stamp in quotes.
  • You can specify ‘yyyy’ as a four-digit year or as a two-digit year. A two-digit year is assumed to exist in a sliding window of -70 through +29 from the current year.
  • ddd’ is the Julian day of the year. You must specify ‘ddd’ as three digits, using leading zeroes if necessary.
  • hh’, ‘mm’, ‘ss’, and ‘t’ are hours, minutes, seconds, and tenths of seconds, respectively. You must specify hours, minutes, and seconds as two digits each, using leading zeroes if necessary.
  • Hours must be expressed in 24-hour time, as a value between 00 and 24.
  • All time stamp parts following ‘ddd’ are optional and can be truncated. Message Advisor treats any truncated parts as if you specified zeroes for those parts. For the STOP keyword, Message Advisor treats any truncated parts as if you specified 23:59:59. For example, if you specify START=2020.123,STOP=2020.123, all messages for that date are included.

Note

Some time stamp specifications can be ambiguous. For example, Message Advisor could interpret ‘202012315’ as ‘2020.123/15:00:00’ or ‘20.201/23:15:00’. Use delimiters to avoid ambiguity. Message Advisor generates a syntax error for ambiguous time stamps.

This section contains the following topics:

 

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