16.20 - Examples: Query Returns for SELECT TRUNC - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Functions, Expressions, and Predicates

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

The following query returns the result 32.4500.

   SELECT TRUNC(32.4567, 2);

The following query returns the result 30.0000.

   SELECT TRUNC(32.4567, -1);