Determines whether the TRUNC and ROUND system functions return a TIMESTAMP or DATE value when passed a TIMESTAMP value.
Field Group
General
Valid Settings
| Setting | Description |
|---|---|
| TRUE | TRUNC and ROUND return a TIMESTAMP data type value when passed a TIMESTAMP value. |
| FALSE | TRUNC and ROUND return a DATE data type value when passed a TIMESTAMP value. |
Default
FALSE
Changes Take Effect
After the next database restart.
Usage Notes
The default behavior of returning a DATE value when passed a TIMESTAMP value is for compatibility with Teradata Database releases prior to 16.10.
Related Information
For more information on the TRUNC and ROUND system functions, see SQL Functions, Expressions, and Predicates, B035-1145.