Breaking News: Grepper is joining You.com. Read the official announcement!

hex string sql becomes int64

Filthy Fish answered on December 2, 2021 Popularity 1/10 Helpfulness 1/10

answer hex string sql becomes int64

hex string sql becomes int64

Comment

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))));

Popularity 1/10 Helpfulness 1/10 Language sql

Source: blog.0101010.com

Tags: hex int64 sql string

Link to this answer
Share Copy Link

Contributed on Dec 02 2021

Filthy Fish

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

hex string sql becomes int64

Contents

More Related Answers

hex string sql becomes int64

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.