Nota
L-aċċess għal din il-paġna jeħtieġ l-awtorizzazzjoni. Tista’ tipprova tidħol jew tibdel id-direttorji.
L-aċċess għal din il-paġna jeħtieġ l-awtorizzazzjoni. Tista’ tipprova tibdel id-direttorji.
Applies to:
Databricks SQL
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, Azure Databricks raises a CAST_INVALID_INPUT error. If the value overflows the BIGINT range, Azure Databricks raises a CAST_OVERFLOW error.
Common error conditions
Examples
> SELECT bigint(current_timestamp);
1616168320
> SELECT bigint('5');
5
> SELECT bigint('abc');
Error: CAST_INVALID_INPUT