DB2 graphic  QMF Version 8

Edit codes for time data

In Table 18, 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.

Table 18. Clock Format Edit Codes
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

Default time format

TT Displays time in the format specified at the database requestor.

Time edit code examples

The examples in Table 19, following, show the time, 1:25:10 PM, formatted with various time edit codes.

Table 19. Time format 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


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004