17,078
社区成员
发帖
与我相关
我的任务
分享
select TO_NUMBER(substr(HEX_TO_RAW(ageing_a),1,5)) age1,
TO_NUMBER(substr(HEX_TO_RAW(ageing_a),6,5)) age2,
TO_NUMBER(substr(HEX_TO_RAW(ageing_a),11,5)) age3,
TO_NUMBER(substr(HEX_TO_RAW(ageing_a),16,5)) age4,
TO_NUMBER(substr(HEX_TO_RAW(ageing_a),21,5)) age5,
TO_NUMBER(substr(HEX_TO_RAW(ageing_a),26,5)) age6
from tablename