DATE

Formats the field using the DATE-EDIT-MASK from the current locale. (See ALTER-LOCALE.) If not defined, the date prints according to the rules in Table 54.

Table 54. Date Formats if Column Type Not Set

Column Type	Default Mask	If not set
DATETIME	SQR_DB_DATE_FORMAT	See Table 61, Default Formats by Database for the format.
DATE	SQR_DB_DATE_ONLY_FORMAT	See Table 61, Default Formats by Database for the format.
TIME	SQR_DB_TIME_ONLY_FORMAT	See Table 63, TIME Column Formats for the format.

You cannot use DATE with numeric columns or variables.