Str2bigint

sql

FUNCTION Str2bigint(IN s CHAR(n)) RETURNS BIGINT;

Parameters

s character string containing a bigint type number notation

Since version

7.0

Description

The Str2bigint function converts the number notation in the s string into the bigint type value and returns that value. Empty string will be converted into NULL. You may also the similar CAST SQL function.

Function value

This function returns a big integer value, if the s string has the appropriate notation. Otherwise NULL is returned.

See