先截取左边4位,再转换:
conv(left(t1.DEVICEID, 4), 16, 10) //转十进制
conv(left(t1.DEVICEID, 4), 10, 16) //转16进制
先截取左边4位,再转换:
conv(left(t1.DEVICEID, 4), 16, 10) //转十进制
conv(left(t1.DEVICEID, 4), 10, 16) //转16进制
转载于:https://www.cnblogs.com/jimmyshan-study/p/10775782.html