79685359

Date: 2025-06-30 23:08:18
Score: 2.5
Natty:
Report link

I had a value of 000D (hex) coming from a table and was finally able to get something like this to work which correctly converted the data to decimal value of 13.

select interpret(BX'0000000D' as integer)

as mentioned here: https://www.ibm.com/support/pages/interpret-built-function

Reasons:
  • Low length (0.5):
  • No code block (0.5):
  • Unregistered user (0.5):
  • Low reputation (1):
Posted by: Toby Newsome