Example 1: Changing the DATE format to SQL99

    In the following example, SQL issues an error because, by
    default, the DATE data type is in OpenVMS DATE format. That is,
    it contains the fields YEAR through SECOND. The SET DEFAULT DATE
    FORMAT statement changes the default to ANSI/ISO format so that
    the CURRENT_DATE and DATE types are compatible.

    SQL> set default date format 'VMS';
    SQL> --
    SQL> create domain LOGGING_DATE
    cont>     DATE
    cont>     default CURRENT_DATE;
    %SQL-F-DEFVALINC, You specified a default value for LOGGING_DATE
    which is inconsistent with its data type
    SQL> --
    SQL> set default date format 'SQL99';
    SQL> --
    SQL> create domain LOGGING_DATE
    cont>     DATE
    cont>     default CURRENT_DATE;
    SQL> show domain LOGGING_DATE;
    LOGGING_DATE                    DATE ANSI
     Oracle Rdb default: CURRENT_DATE