Controls the default interpretation for columns with the DATE or
CURRENT_TIMESTAMP data type. The DATE and CURRENT_TIMESTAMP data
types can be either VMS or SQL 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, like a TIMESTAMP.
If you specify an SQL standard such as SQL99, both data types are
interpreted as SQL 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 ANSI_DATE
qualifier, because the qualifier will be deprecated in a future
release.