Controls the reformatting of date values in output parameters and in input parameter character host variables when DETECTDATE is also specified.
Syntax
DATE={ODBC | ISO | USA | EUR | JIS}
Parameters:
- ODBC
- yyyy-mm-dd
- ISO
- yyyy-mm-dd
- USA
- mm/dd/yyyy
- EUR
- dd.mm.yyyy
- JIS
- yyyy-mm-dd
Dependencies:
Requires that the DETECTDATE SQL directive also be set for input host parameters.
Scope:
| Used at compile time:
|
Yes
|
| Behavior at run time:
|
Source file
|
See
Scope - OpenESQL SQL Compiler Directive Options for more information.
Comments:
DATE changes the display format of output host variables as specified.
In addition, DATE scans input character host variables to identify those that match the DATE format. DATE then converts the contents of the host variables matching the DATE format to the date format of the DBMS.
You can use the DATEDELIM directive to override the default delimiter used in the output format to separate day, month, and year components.
