decimal function

October 10, 2023

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Casts the value expr to DECIMAL. This function is a synonym for CAST(expr AS decimal(10, 0)). See cast function for details.

In this article:

Syntax 

decimal(expr)

Arguments

  • expr: An expression that can be cast to DECIMAL.

Returns

The result is DECIMAL(10, 0).

Examples

SQL
> SELECT decimal('5.2');
 5