dateformat

String value to specify the date format used when the date value is represented in a string. Supported values are:

  • YYYY-MM-DD (default)
  • YYYY/MM/DD
  • DD-MM-YYYY
  • DD/MM/YYYY
  • MM-DD-YYYY
  • MM/DD/YYYY
Default Value

If the dateformat option is not defined, the default value of "YYYY-MM-DD" is used.

Example
dateformat="YYYY-MM-DD"
SQL Options

This option key is associated with the SQL Connection Handle and can be set or retrieved using:

See also
SQL SET statements
SQLSetConnectAttr()
SQLGetConnectAttr()
Note
SQL options can also be associated with the RDM_DB handle along with the Database Configuration Options.