请问下面SQL,在SYSBASE中怎样实现进制转换,截断,用.连接,谢谢
我试验了一些可是实在是对SYSBASE不熟,加油学习
- concat_ws('.',
- conv(substring(hex(devip), 9, 2), 16, 10),
- conv(substring(hex(devip), 11, 2), 16, 10),
- conv(substring(hex(devip), 13, 2), 16, 10),
- conv(substring(hex(devip), 15, 2), 16, 10))
复制代码
是在MYSQL中可以成功执行的SQL。
- select distinct '508001' + ':105:' +
- concat_ws('.',
- conv(substring(hex(devip), 9, 2), 16, 10),
- conv(substring(hex(devip), 11, 2), 16, 10),
- conv(substring(hex(devip), 13, 2), 16, 10),
- conv(substring(hex(devip), 15, 2), 16, 10)) object_rdn,
- 20030205 ne_id,
- time10 scan_start_time,
- 508001 omc_id,
- concat_ws('.',
- conv(substring(hex(devip), 9, 2), 16, 10),
- conv(substring(hex(devip), 11, 2), 16, 10),
- conv(substring(hex(devip), 13, 2), 16, 10),
- conv(substring(hex(devip), 15, 2), 16, 10)) ne_name,
- tbl_perf_sms_rpta.*
- from tbl_perf_sms_rpta
- WHERE 1 = 1 AND time10 >;= {ts '2005-10-14 14:00:00' }
- AND time10 < {ts'2005-10-14 15:00:00' }
复制代码 |