1
vote
Convert hex string representation to hex number in SQL Server T-SQL
You can just convert it to binary(2) with style 2, and then concat it with 0x0000 (the binary value, not a string)
SELECT 0x0000 + CONVERT(binary(2), '16A1', 2);
db<>fiddle
- 11.7k
1
vote
Accepted
Convert hex string representation to hex number in SQL Server T-SQL
I'm not aware of a function to specifically do that but it's easy enough to accomplish with the following:
SELECT
'0x' + RIGHT('00000000' + '16A1', 8) AS SomeHexString
Example dbfiddle.uk
As in ...
- 35.1k
1
vote
Accepted
Covert from literal HEX value to INT MariaDB
If you need to convert hexadecimal representation to decimal one then you must use CONV() function.
SELECT CONV('ff', 16, 10);
| CONV('ff', 16, 10) |
| :----------------- |
| 255 |
...
- 19.4k
1
vote
64 bit hexadecimal AS Date in SQL
This value is encrypted by QlikView to prevent you from tampering with the value.
Some fields in the generated XML file i.e. "LastUsed", are encrypted
for security reasons, thus cannot be ...
- 45.9k
Only top scored, non community-wiki answers of a minimum length are eligible