Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Jean Sagi — — source: Usenet: comp.databases.informix
Amazing indeed !
select '0xC'::integer
from dual
;
As I see it the magic is in the casting !
Chucho!
-----Original Message-----
From: Rajib Sarkar <rsarkar@us.ibm.com>
To: darren.edgerton@reece.com.au
Date: Wed, 5 Jan 2005 13:00:28 -0700
Subject: Re: how do you convert from hex to integer using SQL ?
Its pretty simple actually ..:-)
u can try something like:
select '0xa' + 0 from systables where tabid = 1;
It'll print the integer value of the hex. U can substitute ur column
instead of the hard-coded value in the example.
Thanx much,
Rajib Sarkar
Advisory Software Engineer
DB2/UDB Regional Advanced Support
IBM Data Management Group
If we all did the things we are capable of doing, we would literally
astound ourselves. -- T. Edison
darren.edgerton@r
eece.com.au
Sent by: To
owner-informix-li informix-list@iiug.org
st@iiug.org cc
Subject
01/05/2005 12:09 how do you convert from hex to
AM integer using SQL ?
Please respond to
darren.edgerton
Hi,
i need to conv from Hex to Integer
can this be done using SQL with Informix ??
ie
select integer(hex_data_column) from mytable
thanks,
DSE
Jean Sagi
jeansagi@myrealbox.com
jeansagi@yahoo.com
sending to informix-list
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.