@TOC
案例
sql语句
select
COIL_NO,
FLAG,
CREATE_TIME as RECORD_TIME,
GROUP,
SCORE,
ERROR_TYPE,
STAFF_NAME,
**** CAST('sickleResult' as VARCHAR) as itemName, **** 方案一
//生成一个当前时
**** CAST( VARCHAR_FORMAT(CURRENT TIMESTAMP, 'YYYY-MM-DD HH24:MM:SS') as VARCHAR), **** 方案一
**** 'sickleResult' ITEM_NAME **** 方案二
as CREATE_TIME
from PDPB_SICKLE_LOCAL_JUDGE
where CREATE_TIME BETWEEN '2021-06-17 00:00:00' AND '2021-06-18 00:00:00'
and SCORE != 100.0;
方法介绍
- 方法1
通过 ***'默认值' 新增的列名*** 方式
- 方法2
CAST('默认值' as '自定义的字段类型') as '列名'