hex function doesn't return what I expect

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Desmodromic

    hex function doesn't return what I expect

    I was expecting the following statement to return the hex value of
    10010000. As you can see below, it doesn't. Any idea why not?


    $ db2 "select hex(268500992) from sysibm.sysdummy 1"

    1
    --------
    00000110

    1 record(s) selected.


    Thanks,

    Mike
Working...