CREATE OR REPLACE FUNCTION datediff (p_d1 IN DATE, p_d2 IN DATE) RETURN NUMBERAS l_result NUMBER;BEGIN SELECT (p_d2 - p_d1) + 1 INTO l_result FROM DUAL; RETURN l_result;END;