TRUNC(Date) Function | SQL Date/Time Functions & Expressions | Teradata Vantage - 17.10 - TRUNC(Date) - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Date and Time Functions and Expressions

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

Truncates date_value based on the format specified by fmt.

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.

Result Type

TRUNC is a scalar function whose return data type is DATE.

If the data type of date_value is TIMESTAMP or TIMESTAMP WITH TIME ZONE, the return data type is DATE by default. If you want this function to return a TIMESTAMP value when you pass in TIMESTAMP as input, you must set the TruncRoundReturnTimestamp DBS Control field to TRUE.