Date Alias Setting
The date_alias configuration parameter controls whether the keyword DATE used to define a column data type refers to the ANSIDATE or INGRESDATE data type. It also controls the date() function behaviour as the date(expr) function converts the input expression to the DATE_ALIAS defined representation. During installation, this parameter is assigned a value by default. The setting can be changed during a custom installation.
The setting can also be changed after installation. The date_alias parameter, which is not available in the configuration utilities, must be set with the iisetres command, as follows:
iisetres ii.machine.config.date_alias value
where machine is the machine name, and value is either ANSIDATE or INGRESDATE.
Last modified date: 08/14/2024