Controls the reformatting of date values in output parameters and in input parameter character host variables when DETECTDATE is also used.
Syntax:
TIME={ODBC | ISO | USA | EUR | JIS}
Parameters:
- ODBC
- hh:mm:ss
- ISO
- hh.mm.ss
- USA
- hh:mm {AM | PM}
- EUR
- hh.mm.ss
- JIS
- hh:mm:ss
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:
TIME changes the display format of output host variables as specified.
In addition, TIME scans input character host variables to identify those that match the TIME format. TIME then converts the contents of the host variables matching the TIME format to the time format of the DBMS.
The following apply to USA format:
- Minutes can be omitted. For example, 1 PM is equivalent to 1:00 PM.
- AM and PM are not case sensitive.
- There must be a single blank before AM or PM.
- The hour must not be greater than 12 and cannot be 0 except for the special case of 00:00 AM.
You can use the TIMEDELIM directive to override the default delimiter used in the output format to separate hours, minutes, and seconds components.
