I'm working with a database where colors are stored as integers. For some unknown reason, they are negative integers actually.
Now, I need to use them in the CSS background-color
property, which accepts color names, RGB colors or hexadecimal colors. The problem is I don't know how to convert them correctly to get an acceptable string value.
I tried converting -65280
with CONVERT(VARBINARY(8), abs(S.Color))
and I'm obtaining 0x0000FF00
. What I need as output, however, is either #00ff00
or rgb(0,255,0)
. How can I achieve that?