select * from tese
where update_day="2020-10-18"
运行时报错:
ORA-01861: literal does not match format string
是日期格式不对,修改成如下:
select * from tese
where update_day=to_date('2020-10-18 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
select * from tese
where update_day="2020-10-18"
运行时报错:
ORA-01861: literal does not match format string
是日期格式不对,修改成如下:
select * from tese
where update_day=to_date('2020-10-18 00:00:00', 'yyyy-mm-dd hh24:mi:ss')