sql时间比较

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');