Sql

Search

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

Comment

PREVIOUS	NEXT

Code Example
Sql :: does laravel validate sql
Sql :: can we compare two timestamps in mysql
Sql :: mysql edit trigger
Sql :: install package for sqlserver in asp.net core
Sql :: check sql query executed wp
Sql :: Mysql select all where count more than"
Sql :: mysql read row
Sql :: oracle date winter time
Sql :: dataframe lambda elif
Sql :: django mysqlclient connection string
Sql :: mysql faster delete
Sql :: oracle create job if not exists
Sql :: mysql master slave setup with keepalived
Sql :: mysql primary vs unique
Sql :: How is the default tablespace determined when creating a table?
Sql :: doing calculations in mysql
Sql :: date to month name in mysql query
Sql :: sql alchemy escape ; in insert statement
Sql :: Bigquery insert issue
Sql :: ring close the connection to the database using the odbc_disconnect()
Sql :: script all indexes in a database
Sql :: what is union in sql
Sql :: microsoft sql server import bak file
Sql :: delete in sql server
Sql :: sql int size
Sql :: xamarin sql lite create table if not exist
Csharp :: raycast from camera to mouse unity
Csharp :: how to change scenes on collision unity
Csharp :: how to convert string to guid c#
Csharp :: c# bytes to string

Search

SQL

hex string sql becomes int64

ADD CONTENT