date类型

select * from t_base_employee t where t.modify_time>to_date('2018-06-28 00:00:00','yyyy-mm-dd hh24:mi:ss') and t.modify_time<to_date('2018-06-29 12:00:00','yyyy-mm-dd hh24:mi:ss');

char类型

select * from Hr_Emp_Org_v t where t.C_OPERATE_TIME>'2018-06-28 00:00:00' and t.C_OPERATE_TIME<'2018-06-29 12:00:00' and t.C_EMPLOYEE_STATUS='在职'

timestamp类型

select *  from Tb_Sta_Emp t where t.C_OPERATE_TIME >       to_timestamp('2018-06-28 00:00:0.000000000',                                        'yyyy-mm-dd hh24:mi:ss.ff9');