Sample Header Ad - 728x90

Convert BIGINT to hexadecimal (string) in MonetDB

0 votes
0 answers
569 views
I have a column of type BIGINT in my MonetDB database and for readability I'd like to print its contents as hexadecimal number when executing a SELECTstatement. Is there any way to achieve this? I read through the MonetDB documentation, looking for a function such as HEX(), CONV() etc. but could not find anything like that (or close). I even read through the defined functions (SELECT name FROM sys.functions;) with no luck. P.S. I'm not allowed to create the tag *monetdb* here due to lack of reputation. Could someone please add this tag for me? (This is quite annoying since I am forced to select a tag on none of the existing seems appropriate to me here…)
Asked by dasup (223 rep)
Jul 2, 2019, 04:40 PM
Last activity: Jul 2, 2019, 04:44 PM