TRUNC Function | VantageCloud Lake - TRUNC - Teradata Vantage

Returns numeric_value truncated places_value places to the right or left of the decimal point.

TRUNC is an embedded services system function. For information on activating and invoking embedded services functions, see Embedded Services System Functions.

• TRUNC Function Syntax
• TRUNC Argument Types and Rules
• TRUNC Result Type
• TRUNC Usage Notes
• Examples: Query Returns for SELECT TRUNC

ANSI Compliance

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