When you define the DateTime format for a time field, you tell Analyzer which characters represent the hour, the minutes and the seconds. Analyzer uses the following format characters to represent the elements of a date field:
|
Format Characters |
Date Element |
|
HH |
Hour (00–23) or (1-12) with AM/PM indicator |
|
MM |
Minutes (00–59) |
|
SS |
Seconds (00–59) |
|
A/P or AM/PM |
A/P or AM/PM 12 Hour Clock designation (optional) - if not present in the Time format then 24 hour clock is assumed. |
Put separators such as the colon symbol (:) in the same relative position as they are in the source data file. If you do not, Analyzer will not interpret the time correctly. The format that you define must match the format of the stored time.