ON | OFF

    Specifies the default interpretation for columns with the DATE
    data type, and the data type of the CURRENT_TIMESTAMP function.

    The DATE and CURRENT_TIMESTAMP data types, can be either VMS
    ADT or ANSI. By default, both data types are interpreted as DATE
    VMS. The VMS format contains YEAR TO SECOND fields, just as a
    TIMESTAMP does.

    You can change DATE and CURRENT_TIMESTAMP to ANSI format with
    the SET DEFAULT DATE FORMAT statement, the precompiler DEFAULT
    DATE FORMAT clause in a DECLARE MODULE statement embedded in a
    program, or the module language DEFAULT DATE FORMAT clause in a
    module file. The ANSI format DATE contains only the YEAR TO DAY
    fields.

    You must use the SET DEFAULT DATE FORMAT statement before
    creating domains or tables. You cannot use this statement to
    modify the data type once you have created a column or table.