仅支持如下写法:
select * from T_E003_SEND_FEE where to_char(DT_SUMDATE,'yyyy-MM-dd') = '2019-05-05'
不支持如下写法,否则会报错:
select * from T_E003_SEND_FEE where DT_SUMDATE = to_char(2019-05-05','yyyy-MM-dd')
仅支持如下写法:
select * from T_E003_SEND_FEE where to_char(DT_SUMDATE,'yyyy-MM-dd') = '2019-05-05'
不支持如下写法,否则会报错:
select * from T_E003_SEND_FEE where DT_SUMDATE = to_char(2019-05-05','yyyy-MM-dd')