日期字段用字符来存取 ,后面想要转换成日期类型,那么要写函数char_to_date:
CREATE OR REPLACE FUNCTION char_to_date (datestr VARCHAR2)
RETURN date
IS
p_date DATE;
BEGIN
SELECT TO_DATE (datestr,'yyyy-MM-dd hh24:mi:ss')
INTO p_date
FROM DUAL;
RETURN (p_date);
EXCEPTION
WHEN OTHERS
THEN
RETURN null;
END;