Syntax options:

    DEFAULT DATE FORMAT { SQL99 | SQL92 | VMS }

    Controls the default interpretation for the data type of
    the CURRENT_TIMESTAMP built in function and column or CAST
    expressions with the DATE data type. The DATE and CURRENT_
    TIMESTAMP data types can be either VMS or ANSI/ISO Standard
    format.

    If you specify VMS, both data types are interpreted as VMS
    format. The VMS format DATE and CURRENT_TIMESTAMP contain YEAR
    TO SECOND fields.

    If you specify SQL99 or SQL92, both data types are interpreted as
    SQL standard format. The SQL format DATE contains only the YEAR
    TO DAY fields.

    The default is VMS.

    Use the DEFAULT DATE FORMAT clause, rather than the SQLOPTIONS =
    ANSI_DATE qualifier because the qualifier will be deprecated in a
    future release.