hex_to_int(substring(“3G小区”,1,4))::varchar(255)||hex_to_int(substring(“3G小区”,5,8))::varchar(255),
SELECT to_char(12345, ‘9999999999999999999’)//结果‘ 12345’,结果字符串前面有空格,位数跟格式化模式中9的位数有关;
SELECT to_char(12345, ‘99999’)//结果‘12345’
SELECT to_char(12345, ‘9999’)//结果‘####’,当模式串小于数字个数时,字符串会显示为#,位数跟格式化模式中9的位数有关;
SELECT to_char(12345, ‘’)//结果‘’