Use of this function converts a value to a BIGINT.

Syntax

BIGINT ( charExpression | numExpression )

Arguments

  • charExpression: A string value that results in a SQL integer constant.
  • numExpression: A numeric expression in the range of a BIGINT. Any decimal component of the value will be truncated.

Returns

  • A BIGINT value. See BIGINT

  • Returns NULL if the argument is NULL.

Examples

VALUES BIGINT(54782908.22);
-- Returns 54782908