In Table 17, following, x represents the character to be used as a delimiter between time values. It can be any special character, including blank, but not letters or numbers.
| Edit Code | Format | Notes |
|---|---|---|
| TTSx | HHxMMxSS | 24-hour clock, including seconds |
| TTCx | HHxMMxSS | 12-hour clock, including seconds |
| TTAx | HHxMM | Abbreviated (no seconds) |
| TTAN | HHMM | Abbreviated (no seconds, no delimiter) |
| TTUx | HHxMM AM HHxMM PM | USA format |
| TTL | Locally defined. | See your QMF administrator for format information |
TT Displays time in the format specified at the database requestor.
The examples in Table 18, following, show the time, 1:25:10 PM, formatted with various time edit codes.
| Edit Code | Format | Notes |
|---|---|---|
| TTS. | 13.25.10 | ISO, European formats |
| TTS: | 13:25:10 | JIS format |
| TTU: | 01:25 PM | USA format |
| TTS, | 13,25,10 | Hours, minutes, seconds (24 hr.), delimiter: comma (,) |
| TTC: | 01:25:10 | Hours, minutes, seconds (12 hr.), delimiter: colon (:) |
| TTA. | 13.25 | Hours, minutes (24 hr.), delimiter: period (.) |
| TTA, | 13,25 | Hours, minutes (24 hr.), delimiter: comma (,) |
| TTAN | 1325 | Hours, minutes (24 hr.), no delimiter |