VMS Help  —  SQLMOD72  Arguments  DEFAULT_DATE_FORMAT
    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.
Close Help