在对MySQL查询有时需要对数据类型进行转换,
select数据类型转换的主要点是:cast(datatype01
as
UNSIGNED datatype)
说明:将字段datatype01 的数据型转换成datatype
如:
select SERIAL_NUM,CHAMBER, SLOT,TUID,EVENT_DATE,K_DATA_UNITS_WRITTEN,cast(K_DATA_UNITS_READ as UNSIGNED INTEGER) K_DATA_UNITS_READ,power_on_hours
from tb_smart_health_info
where serial_num in ('MBKA15JE0109A01','MBK704J40140A02')
order by event_date desc