-- varchar2类型
select *
from ZT_HWBK_RLZYBZGL
where substr(CREATE_TIME,0,7)='2020-03'
-- date 类型
select *
from ZT_GCJJ_SXQQ_YSS
where to_char(TZJSSJ,'yyyy-MM')='2021-01'
-- varchar2类型
select *
from ZT_HWBK_RLZYBZGL
where substr(CREATE_TIME,0,7)='2020-03'
-- date 类型
select *
from ZT_GCJJ_SXQQ_YSS
where to_char(TZJSSJ,'yyyy-MM')='2021-01'