DB2 graphic  QMF Version 8

Edit codes for date data

In the following edit codes, x represents the character to be used as a delimiter between date values. It can be any special character, including blank, but not letters or numbers.

Default date format

TD Displays dates in the format specified at the database requestor.

Four-digit year:

TDYx Year first YYYYxMMxDD
TDMx Month first MMxDDxYYYY
TDDx Day first DDxMMxYYYY

Abbreviated two-digit year:

TDYAx Year first YYxMMxDD
TDMAx Month first MMxDDxYY
TDDAx Day first DDxMMxYY

Alternative date format:

TDL
Locally defined. See your QMF administrator for format information.
Date edit code examples

The examples in Table 17, following, show the date July 17, 1989, formatted with various date edit codes.

Table 17. Date edit code examples
Edit Code Format Notes
TDD. 17.07.1989 European format
TDY- 1989-07-17 International Standards Organization (ISO) and Japanese Industrial Standard (JIS) formats
TDM/ 07/17/1989 USA format
TDD- 17-07-1989 Four-digit year, day first, delimiter: dash (-)
TDDA/ 17/07/89 Two-digit year, day first, delimiter: slash (/)
TDDA. 17.07.89 Two-digit year, day first, delimiter: period (.)
TDDA- 17-07-89 Two-digit year, day first, delimiter: dash (-)
TDDA 17 07 89 Two-digit year, day first, delimiter: blank ( )
TDMA/ 07/17/89 Two-digit year, month first, delimiter: slash (/)
TDMA- 07-17-89 Two-digit year, month first, delimiter: dash (-)
TDYA/ 89/07/17 Two-digit year, year first, delimiter: slash (/)


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