比较oracle两表中date类型数据是否一致语句查询
select * from temp_info t inner join PURCHASE_BASE_INFO p on to_char(t.CREATE_TIME,'yyyy-mm-dd') = to_char(p.CREATE_TIME,'yyyy-mm-dd')
select * from temp_info t inner join PURCHASE_BASE_INFO p on to_char(t.CREATE_TIME,'yyyy-mm-dd') = to_char(p.CREATE_TIME,'yyyy-mm-dd')