int function

Applies to: Databricks SQL Databricks Runtime

Casts the value expr to INTEGER. This function is a synonym for CAST(expr AS INTEGER).

Syntax

int(expr)

Arguments

• expr: Any expression which is castable to INTEGER.

Returns

An INTEGER.

Examples

> SELECT int(-5.6);
 -5
> SELECT int('5');
 5

Related functions

• cast function