Purpose
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 Teradata 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 Topics
For more information on the TRUNC and ROUND system functions, see SQL Functions, Operators, Expressions, and Predicates.