DATE

Specifies the date format to be used with this program.

Syntax:

DATE={date-format}

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 .

Default:

Use the default settings defined by the IDE, using Options > SQL for DB2 .

Use this directive to override the default settings.