Time information is stored in many different formats. Times are usually represented with a combination of numbers, characters (a.m. and p.m.) and punctuation (typically separating colons). Analyzer uses a DateTime format to identify the byte positions in a time field that represent the hour, minute and second information as well as optional AM/PM indicators.
The DateTime format for defining a time field is:
HH:MM:SS <P|PM>
By default, a 24 hour clock is assumed when interpreting the time. If the DateTime format includes the optional AM/PM indicator then the time will be interpreted using a 12 hour clock format. The DateTime format does not affect the way time is displayed in Analyzer. Time is always displayed using a 24 hour clock.
The Data Definition Wizard does not automatically detect time fields. The DateTime format for time fields must be manually entered in the Wizard.