强制转换视图某个字段为某个类型的sql

select cast(`a`.`status` AS SIGNED INTEGER) AS `status`,`a`.`TAGNAME` AS `TAGNAME` from (select truncate(`v_mes_snapshots`.`numbervalue`,0) AS `status
posted on 2024-04-10 09:38  坚持就有光  阅读(9)  评论(0)  编辑  收藏  举报