CREATE OR REPLACE FUNCTION FN_CX_DATE RETURN DATE IS
V_DAYS_VARIANCE NUMBER;
V_DATE DATE;
BEGIN
V_DAYS_VARIANCE := 10;
SELECT TO_DATE(TO_CHAR(TRUNC(SYSDATE) - V_DAYS_VARIANCE,
'YYYY-MM-DD') || ' 23:59:59',
'YYYY-MM-DD HH24:mi:ss')
INTO V_DATE
FROM DUAL;
RETURN(V_DATE);
END FN_CX_DATE;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/206955/viewspace-767052/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/206955/viewspace-767052/