cast(P_YEAR||P_MONTH AS DATE) "日期",
参考https://blog.csdn.net/weixin_45971146/article/details/108779939
select to_date(replace(replace('2020年3月','年','-'),'月','-')||'01','yyyy-mm-dd') as ttt
select to_date(replace(replace(zyf,'年','-'),'月','-')||'01','yyyy-mm-dd') as ttt
看下这个 https://blog.csdn.net/m0_43393325/article/details/121614735