Syntax

Truncate(Numeric_Expression)

Input Parameters

Numeric_Expression

A valid double or exact-precision numeric expression to truncate.

Return Value

Returns the integral part of the specified decimal or double-precision floating-point number.

Note: The TRUNCATE() function is not supported when connected to the SparkSQL data warehouse.

Examples

Truncate the Internet Sales Amount Local] Measure to the integral component.

Truncate([Measures].[Internet Sales Amount Local])