1、字符串类型转换为bigint类型
select * from tableName order by cast(字段名 as BIGINT) desc;
2、字符串类型转为时间类型
select * from tableName order by cast(字段名 as TIMESTAMP) desc;
目前就试了这两个,先记录一下
1、字符串类型转换为bigint类型
select * from tableName order by cast(字段名 as BIGINT) desc;
2、字符串类型转为时间类型
select * from tableName order by cast(字段名 as TIMESTAMP) desc;
目前就试了这两个,先记录一下