Museum

Home

Lab Overview

Retrotechnology Articles

⇒ Online Manual

Media Vault

Software Library

Restoration Projects

Artifacts Sought

Related Articles

runtime options

SQL92

VMS

RDB/VMS SQL SET_DEFAULT_DATE_FORMAT — VMS RDB_4.2

 SET DEFAULT DATE FORMAT --> runtime-options ----> ;

 SET DEFAULT DATE FORMAT specifies whether columns with the DATE
 or CURRENT_TIMESTAMP data type are interpreted as VMS or SQL92
 format.

 You can use the SET DEFAULT DATE FORMAT statement with
 interactive and dynamic SQL only.

Additional information available:

runtime options

runtime options

 runtime-options

 --+---> 'literal' --------------+-->
   +---> parameter --------------+
   +---> parameter-marker -------+

 The value of runtime-options must be either SQL92 or VMS.

Additional information available:

SQL92VMS

SQL92

 Specifies that the DATE and CURRENT_TIMESTAMP data types are
 interpreted as SQL92 format.  The SQL92 format DATE contains
 only the YEAR to DAY fields.

VMS

 Specifies that the DATE and CURRENT_TIMESTAMP data types are
 interpreted as VMS format.  A VMS format data type is compatible
 with Rdb/ELN and versions of Rdb/VMS prior to Version 4.1, but
 cannot be used in date-time arithmetic.  The VMS format DATE and
 CURRENT_TIMESTAMP contain YEAR to SECOND fields.

 The default is VMS.

Typewritten Software • bear@typewritten.org • Edmonds, WA 98026