Skip to main content

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

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