The configuration parameter date_alias (which was introduced in Ingres 2006 Release 2 and replaces date_type_alias parameter) controls whether the keyword DATE used to define the column data type refers to the INGRESDATE (default) or ANSIDATE data type.

In this release (Ingres 9.2), the value of date_alias is communicated from the client to the server. If the client and server have different values for date_alias, then the server uses the date_alias value set in the config.dat file on the client. This ensures that the definition of date_alias intended at the client is preserved in communication to the server.

To change the value of date_alias in the config.dat file, use the iisetres command. For details on the iisetres command, see the Command Reference Guide.