When used in addition to DETECTDATE, specifies the explicit time format to recognize in character input host variables.
TIME={ODBC | ISO | USA | EUR | JIS}
Default: | ODBC (ISO 8601 default format) |
For input host parameters, requires that the DETECTDATE SQL compiler directive is also set.
Used at compile time: | Yes |
Behavior at run time: | Source file |
See Scope - OpenESQL SQL Compiler Directive Options for more information.
TIME can be used with the TIMEDELIM directive to specify an alternative delimiter that separates hour, minute, and second components.
TIME, with or without TIMEDELIM, changes the display format of output host variables as specified.
When you specify both TIME and DETECTDATE, OpenESQL uses TIME (with or without TIMEDELIM) to also recognize time values in your input host variables. See DETECTDATE for more information