Skip to main content

bigint function

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

Casts the value expr to BIGINT. This function is a synonym for CAST(expr AS BIGINT). See cast function for details.

Syntax

bigint(expr)

Arguments

  • expr: Any expression which is castable to BIGINT.

Returns

A BIGINT.

If expr is a STRING that cannot be parsed as a number, Databricks raises a CAST_INVALID_INPUT error. If the value overflows the BIGINT range, Databricks raises a CAST_OVERFLOW error.

Common error conditions

Examples

SQL
> SELECT bigint(current_timestamp);
1616168320
> SELECT bigint('5');
5

> SELECT bigint('abc');
Error: CAST_INVALID_INPUT