16.10 - TruncRoundReturnTimestamp - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

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.