Cast Data Format Specifications Time Formats

Time formats are used to tell the expression processor the structure of a time value.

The following time format specifications are currently defined.

  • HHMMSS
  • HHMM
  • HHMMSSF
  • HHMMSSFF

where:

F (one digit 10th of a second)

FF (two digit 100th of a second)

HH (two digit hour)

MM (two digit minute)

SS (two digit second)

INTERVAL %HHMMSSFF
QUITTIME %HHMM

 

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