Truncate

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])