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‘)
2021-08-04 08:43:32
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‘)