语法为:Cast(字段名 as 转换的类型 ),其中类型可以为:CHAR[(N)] 字符型DATE 日期型DATETIME 日期和时间型DECIMAL float型SIGNED intTIME 时间型字符类型转整数oracle cast(a as int) bmysql cast(a as SIGNED) b2023-10-11