Home | Previous Page | Next Page   GLS Environment Variables > GLS-Related Environment Variables >

DBDATE

IBM Informix products support the DBDATE environment variable for compatibility with earlier products. We recommend that you use the GL_DATE environment variable for new applications.

The DBDATE environment variable specifies the end-user formats of values in DATE columns. For information about end-user formats, see End-User Formats.

Important:
DBDATE is evaluated at system initialization time. If it is invalid, the system initialization fails.

Read syntax diagramSkip visual syntax diagram                                         (1)
>>-DBDATE--+-| Standard DBDATE Formats |-------+---------------><
           |                              (2)  |
           '-| Era-Based DBDATE Formats |------'

Notes:
  1. see IBM Informix: Guide to SQL Reference
  2. see DBDATE Extensions

Important:
DBDATE variable takes precedence over the GL_DATE environment variable, as well as over the default DATE formats that CLIENT_LOCALE specifies.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]