方式一
SELECT to_date( '20210101', 'yyyyMMdd' )
方式二
select to_date(substr('20180312',1,4)||'-'||substr('20180312',5,2)||'-'||substr('20180312',7,2),'yyyy-MM-dd')
方式三
SELECT '20210728'::date AS occur_dt
方式一
SELECT to_date( '20210101', 'yyyyMMdd' )
方式二
select to_date(substr('20180312',1,4)||'-'||substr('20180312',5,2)||'-'||substr('20180312',7,2),'yyyy-MM-dd')
方式三
SELECT '20210728'::date AS occur_dt