FUNCTION isdate (datestr VARCHAR2, format VARCHAR2) RETURN number IS
p_date DATE;
BEGIN
SELECT TO_DATE (datestr, format)
INTO p_date
FROM DUAL;
RETURN 1;
EXCEPTION
WHEN OTHERS THEN
RETURN 0;
END;
多条件模糊查询时：
function get_date_str ( p_date varchar2) return varchar2 is
v_date date;
begin if ( length(p_date) = 4 ) then
select to_date (p_date, 'yyyy')
into v_date
from dual;
return to_char( v_date ,'yy'); elsif ( length(p_date) = 6 )then
select to_date (p_date, 'yyyymm')
into v_date
from dual;
return to_char( v_date ,'mm') || '月-' || to_char( v_date,'yy'); elsif ( length(p_date) = 7 )then
select to_date (p_date, 'yyyy-mm')
into v_date
from dual;
return to_char( v_date ,'mm') || '月-' || to_char( v_date,'yy'); elsif ( length(p_date) = 8 ) then
select to_date (p_date, 'yyyymmdd')
into v_date
from dual;
return to_char(v_date,'dd') || '-' || to_char( v_date,'mm') || '月-' || to_char(v_date,'yy'); elsif ( length(p_date) = 10 ) then
select to_date (p_date, 'yyyy-mm-dd')
into v_date
from dual;
return to_char(v_date,'dd') || '-' || to_char( v_date,'mm') || '月-' || to_char(v_date,'yy'); end if; return '11-00月-00'; exception
when others then
return '00-00月-00';
end get_date_str;