cast(字段名 as 转换的类型 ),即可以修改输出字段名的类型
举例:date原来的值为 2020-02-28 11:03:58
select cast(date as date) as date from a;
输出:
2020-02-28
select cast(date as time) as date from a;
输出:
11:03:58
cast(字段名 as 转换的类型 ),即可以修改输出字段名的类型
举例:date原来的值为 2020-02-28 11:03:58
select cast(date as date) as date from a;
输出:
2020-02-28
select cast(date as time) as date from a;
输出:
11:03:58