edb_redwood_date v17

DATE can appear as the data type of a column in the commands. To translate it to TIMESTAMP when the table definition is stored in the database, set the configuration parameter edb_redwood_date to TRUE. In this case, a time component is stored in the column with the date. This is consistent with Oracle’s DATE data type.

If edb_redwood_date is set to FALSE, the column’s data type in a CREATE TABLE or ALTER TABLE command remains as a native PostgreSQL DATE data type. It's stored as such in the database. The PostgreSQL DATE data type stores only the date without a time component in the column.

Regardless of the setting of edb_redwood_date, when DATE appears as a data type in any other context, it's always internally translated to a TIMESTAMP and thus can handle a time component if present. These contexts include the data type of a variable in an SPL declaration section or the data type of a formal parameter in an SPL procedure or SPL function or the return type of an SPL function.