Skip to content

Instantly share code, notes, and snippets.

@elaatifi

elaatifi/unhex.sql

Created May 4, 2023 15:38
Show Gist options
  • Save elaatifi/c284163658c43a47dd724db9ae6bc637 to your computer and use it in GitHub Desktop.
Save elaatifi/c284163658c43a47dd724db9ae6bc637 to your computer and use it in GitHub Desktop.
Download ZIP
SQLite unhex, how to convert a hex string back to number
Raw
unhex.sql
SELECT CAST(x'||hex_string AS INTEGER) AS int_value
FROM hex_values;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment