-
CREATE OR REPLACE FUNCTION comm.get_year(start_date DATE,end_date DATE)
-
RETURN NUMBER
-
IS
-
service_interval INTERVAL YEAR TO MONTH;
-
years_of_service NUMBER;
-
BEGIN
-
service_interval := (end_date - start_date) YEAR TO MONTH;
-
years_of_service := EXTRACT(YEAR FROM service_interval);
-
RETURN years_of_service ;
-
END;
-
-
CREATE OR REPLACE FUNCTION comm.get_month(start_date DATE,end_date DATE)
-
RETURN NUMBER
-
IS
-
service_interval INTERVAL YEAR TO MONTH;
-
months_of_service NUMBER;
-
BEGIN
-
service_interval := (end_date - start_date) YEAR TO MONTH;
-
months_of_service := EXTRACT(MONTH FROM service_interval);
-
RETURN months_of_service ;
- END;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/28878983/viewspace-2133885/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
