DBDATE environment variable (deprecated)

The DBDATE environment variable specifies the display formats of values in DATE columns.

HCL Informix® products support the DBDATE environment variable for compatibility with earlier products. It is recommend that you use the GL_DATE environment variable for new applications.

Important: DBDATE is evaluated at system initialization time. If it is invalid, the system initialization fails.
Read syntax diagramSkip visual syntax diagram
>>-DBDATE--+-| Standard DBDATE formats |------+----------------><
           |                              (2) |   
           '-| Era-based DBDATE formats |-----'   

  1. See IBM® Informix Guide to SQL: Reference
  2. See DBDATE extensions (deprecated)
Important: DBDATE variable takes precedence over the GL_DATE environment variable and over the default DATE formats that CLIENT_LOCALE specifies.

Copyright© 2018 HCL Technologies Limited