On 05/27/2014 09:47 AM, saqibrafique wrote:
fm_db_Server1=# *select to_hex(to_number(substr(from_ip, 1, 3), '999')) as
price from operator;*
/ERROR: function to_hex(numeric) does not exist
LINE 1: select to_hex(to_number(substr(from_ip, 1, 3), '999')) as p...
^
There's no to
saqibrafique wrote
> hi guys,
> I am trying to convert a simple char value to HEX but I am getting Error.
>
*
> MyTable:
*
>
> CREATE TABLE mytable (from_ip CHAR(20), to_ip CHAR(20));
*
> I have below values in the Table:
*
>
>
> fm_db_Server1=# select * from operator;
>from_ip
