DATE

Specifies the date format to be used with this program.
Restriction: This topic applies to Windows environments only.

Syntax:

DATE={date-format}

Parameters:

date-format
The format in which date information is to be returned. One of:
ISO yyyy-mm-dd
EUR dd.mm.yyyy
JIS yyyy-mm-dd
USA mm/dd/yyyy
LOCAL format needs to be defined from the IDE, using Options > SQL for DB2 (Windows) or The User Profile utility (UNIX).

Properties:

Default: Use the default settings defined by the IDE, using Options > SQL for DB2 (Windows) or The User Profile utility (UNIX).

Comments:

Use this directive to override the default settings.