[sqlite] hexadecimal conversion on select query

2016-03-14 Thread Cezary H. Noweta
On 2016-03-13 23:14, jungle Boogie wrote: > Hi Keith, > On 13 March 2016 at 13:31, Keith Medcalf wrote: >> On Sunday, 13 March, 2016 13:36 -07:00, jungle Boogie > gmail.com> wrote: >>> Here it is in decimal: (select code from sidemeters) >>> "0" >>> "1" >>> "2" >>> "5" >>> "6" >>> "7" >>> "28"

[sqlite] hexadecimal conversion on select query

2016-03-13 Thread jungle Boogie
Hi Keith, On 13 March 2016 at 13:31, Keith Medcalf wrote: > On Sunday, 13 March, 2016 13:36 -07:00, jungle Boogie gmail.com> wrote: >> Here it is in decimal: (select code from sidemeters) >> "0" >> "1" >> "2" >> "5" >> "6" >> "7" >> "28" >> "29" >> "30" >> "31" > > Assuming that your quotes mean

[sqlite] hexadecimal conversion on select query

2016-03-13 Thread Keith Medcalf
On Sunday, 13 March, 2016 13:36 -07:00, jungle Boogie wrote: > On 12 March 2016 at 22:07, J Decker wrote: > > maybe ? > > https://www.sqlite.org/lang_corefunc.html > > hex(X)The hex() function interprets its argument as a BLOB and returns > > a string which is the upper-case hexadecimal

[sqlite] hexadecimal conversion on select query

2016-03-13 Thread jungle Boogie
On 12 March 2016 at 22:07, J Decker wrote: > maybe ? > https://www.sqlite.org/lang_corefunc.html > > hex(X)The hex() function interprets its argument as a BLOB and returns > a string which is the upper-case hexadecimal rendering of the content > of that blob. That's what I first tried but not

[sqlite] hexadecimal conversion on select query

2016-03-12 Thread J Decker
maybe ? https://www.sqlite.org/lang_corefunc.html hex(X)The hex() function interprets its argument as a BLOB and returns a string which is the upper-case hexadecimal rendering of the content of that blob. On Sat, Mar 12, 2016 at 12:18 PM, jungle Boogie wrote: > Hello All, > > I'm curious to

[sqlite] hexadecimal conversion on select query

2016-03-12 Thread jungle Boogie
Hello All, I'm curious to know if there's a better way to run a query and convert the results to hexadecimal. This is what I have so far: SELECT printf("%x %d",code,code), printf("%x", denom) FROM sidemeters order by denom The data is already in decimal so I don't necessarily need to include