Controls the interpretation of date formats.

For more information about setting the format for dates retrieved from the database, see date_format option [compatibility].

Allowed values

MDY, YMD, DMY

Default

YMD (this corresponds to ISO date format specifications)

For Open Client and jConnect connections, the default is set to MDY

Scope

Can be set for an individual connection or for the PUBLIC group. Takes effect immediately.

Remarks

The database option date_order is used to determine whether 10/11/12 is Oct 11 1912, Nov 12 1910, or Nov 10 1912.