Oracle存储过程中如何将字符串转化成日期类型

create or replace procedure pro_base_equipment_submit(    v_equipment_id in varchar2,    v_equipment_name in varchar2,    v_specification in varchar2,    v_quantity in varchar2,    v_ok_status in varchar2,    v_use_sites in varchar2,    v_scc_gb in varchar2,    v_sc_dt in varchar2,    v_gz_dt in varchar2,    v_enterprise_id in varchar2,    v_sign in varchar2) isbegin    if(v_sign = 1) then    insert into super_enterprise_equipment    (      equipment_id ,      equipment_name,      specification,      quantity,      ok_status,      use_sites,      scc_gb,      sc_dt,      gz_dt,      enterprise_id    )    values    (    seq_equipment_id.NEXTVAL,    v_equipment_name,    v_specification,    v_quantity,    v_ok_status,    v_use_sites,    v_scc_gb,    to_date(v_sc_dt,'YYYY-MM-DD HH24-MI-SS'),    to_date(v_gz_dt,'YYYY-MM-DD HH24-MI-SS'),    v_enterprise_id    );    else    update super_enterprise_equipment set      equipment_name = v_equipment_name,      specification = v_specification,      quantity = v_quantity,      ok_status = v_ok_status,      use_sites = v_use_sites,      scc_gb = v_scc_gb,      sc_dt = to_date(v_sc_dt,'YYYY-MM-DD HH24-MI-SS'),      gz_dt = to_date(v_gz_dt,'YYYY-MM-DD HH24-MI-SS'),      enterprise_id = v_enterprise_id      where equipment_id = v_equipment_id;    end if;  commit;end pro_base_equipment_submit;报错：Caused by: java.sql.SQLException: ORA-01830: 日期格式图片在转换整个输入字符串之前结束ORA-06512: 在 "SA.PRO_BASE_EQUIPMENT_SUBMIT", line 19ORA-06512: 在 line 1

乱七八糟的，你让别人怎么帮你解答~