Hex string sql becomes int64

CREATE TEMP FUNCTION
  hex64ToInt64(hex STRING)
  RETURNS INT64 AS (
    IF(hex < "8000000000000000", 
       cast(concat("0x", hex) AS INT64), 
       (SELECT (((ms32 & 0x7fffffff) << 32) | ls32) - 0x7fffffffffffffff - 1
        FROM (SELECT cast(concat("0x", substr(hex, 1, 8)) AS INT64) AS ms32,
                     cast(concat("0x", substr(hex, 9, 8)) AS INT64) AS ls32))));

Source: blog.0101010.com

Similar codes

4 votes228 views2 answers
Mysql how to change default charset
SQL
8 votes235 views2 answers
Alert table name mysql
SQL
1 vote184 views1 answer
Flask-sqlalchemy filter_by contains
SQL
25 votes251 views3 answers
How to use a database to see tables mysql
SQL
0 vote264 views1 answer
Hour and minute between two datatime sql
SQL
0 vote242 views2 answers
How to tun mysql on ubunto
SQL
6 votes256 views2 answers
Mysqldump password in file
SQL
5 votes236 views1 answer
Oracle asynchronous update
SQL
0 vote257 views1 answer
Mysql Selected All Duplicate Rows
SQL
5 votes213 views1 answer
Mongodb vs
SQL