DBTIME environment variable (deprecated)

The DBTIME environment variable specifies the custom display formats of values in DATETIME columns for SQL API routines in the ESQL/C function libraries.

HCL Informix® products support DBTIME for compatibility with earlier products. It is recommended that you use the GL_DATETIME environment variable for new applications. See also Display formats.
Read syntax diagramSkip visual syntax diagram
                                         (1)      
>>-DBTIME--+-| Standard DBTIME formats |------+----------------><
           |                              (2) |   
           '-| Era-based DBTIME formats |-----'   

Notes:
  1. See IBM Informix Guide to SQL: Reference
  2. See DBTIME support
Tip: DBTIME affects only certain formatting routines in the ESQL/C function libraries. See DATETIME-format functions.

Copyright© 2018 HCL Technologies Limited