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.