alter table common_todo_table modify start_date varchar2(19);
alter table common_todo_table mo
select * from common_todo_table where ( BUSI_TYPE = 'FP_REPORT' or BUSI_TYPE = 'FP_AUDIT' )
and start_date <= '2018-10-22' and end_date >= '2018-10-22'
--日期等于的边界值查不到,,有多出来的空格。。。。。。。
and pk_user like '%0ae4ae55-d06e-4ba2-ab79-b73ab3381459%';dify end_date varchar2(19);