RE: Re: how do you convert from hex to integer using SQL ?
Try '0x0' instead of '0xa'. That should do the trick. :)
Cheers,
Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Data Management Solutions
owner-informix-list@iiug.org wrote on 06.01.2005 14:52:46:
>
> Sebastian, Norma J. said:
> >
> > Rajib,
> >
> > I played with your sql: "select '0xa' + 0 from systables where tabid
=
> > 1;" ... "It'll print the integer value of the hex"
> >
> > I ran this:
> > select tabname, partnum,
> > hex(partnum), ('0xa' + hex(partnum))
> > from systables>
> 0xa != 0 :o)
>
> > I get results like:
> >
> > tabname ebkpf (SAP table names...)
> > partnum 62914738
> > (expression) 0x03C000B2
> > (expression) 62914748.0000000
> >
> > tabname syschecks
> > partnum 1048716
> > (expression) 0x0010008C
> > (expression) 1048726.00000000
> >
> > tabname syscoldepend
> > partnum 1048718
> > (expression) 0x0010008E
> > (expression) 1048728.00000000
> >
> >
> > Shouldn't the partnum and the second expression be equal based on your
> > suggestion, or am I doing something wrong?
> > Thanks,
> > Norma Jean
> >
> >
> >
> > -----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
> >
> >
> >
> > 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,
> > ============================================================
> > The information contained in this message may be privileged
> > and confidential and protected from disclosure. If the reader
> > of this message is not the intended recipient, or an employee
> > or agent responsible for delivering this message to the
> > intended recipient, you are hereby notified that any reproduction,
> > dissemination or distribution of this communication is strictly
> > prohibited. If you have received this communication in error,
> > please notify us immediately by replying to the message and
> > deleting it from your computer. Thank you. Tellabs
> > ============================================================
> >
> > sending to informix-list
> >
>
>
> --
>
> Bye now,
> Obnoxio
>
> "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule"
> - Coluche
>
> "I'm trying to see things your way, but I can't get my head up my ass"
> - JCH
>
> "Ogni uomo mi guarda come se fossi una testa di cazzo"
> - Marco
>
> I went to the airport to check in and they asked what I did because I
> looked like a terrorist. I said I was a comedian. They said, "Say
> something funny then." I told them I had just graduated from flying
> school.
>
> -- Ahmed Ahmed
> sending to informix-list
sending to informix-list