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 16, following, show the date July 17, 1989, formatted with various date edit codes.

Table 16. 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 (/)

[ Previous Page | Next Page | Contents | Index ]