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
TRUE. In this case, a time component is stored in the column with the date. This is consistent with Oracle’s
DATE data type.
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
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.