split_part(to_char(wco_reg_time, 'YYYY-MM-dd'), '-', 1) as year,
split_part(to_char(wco_reg_time, 'YYYY-MM-dd'), '-', 2) as month,
split_part(to_char(wco_reg_time, 'YYYY-MM-dd'), '-', 3) as day,
OR
to_char (to_date (issue, 'yyyy-MM-dd'), 'yyyy') AS year,
to_char (to_date (issue, 'yyyy-MM-dd'), 'MM') AS month,
to_char (to_date (issue, 'yyyy-MM-dd'), 'dd') AS day,