ASA Database Administration Guide
  Database Options
    Alphabetical list of options

DATE_ORDER option [compatibility]

Function 

Controls the interpretation of date formats.

Allowed values 

'MDY', 'YMD', or 'DMY'

Scope 

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

Default 

YMD. This corresponds to ISO date format specifications.

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

Description 

The database option DATE_ORDER is used to determine whether 10/11/12 is Oct 11 1912, Nov 12 1910, or Nov 10 1912. The option can have the value 'MDY', 'YMD', or 'DMY'.