ROUND(Date) Function | VantageCloud Lake - ROUND(Date) - Teradata VantageCloud Lake

Returns date_value with the time portion of the day rounded to the unit specified by fmt.

• ROUND(Date) Syntax
• ROUND(Date) and TRUNC(Date) Argument Types and Rules
• ROUND(Date) Examples

ANSI Compliance

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

Result Type

ROUND is a scalar function with a return data type of DATE.

If the data type of date_value is TIMESTAMP or TIMESTAMP WITH TIME ZONE, the return data type is DATE by default.