--测试数据 CREATE VIEW V AS SELECT TO_DATE('1-12-20','YYYY-MM-DD') AS DT1,TO_DATE('3-10-24','YYYY-MM-DD') AS DT2 FROM DUAL;--执行语句 SELECT add_months(add_months((dt1+to_char(dt2,'dd')),to_char(dt2,'mm')),3*12) from v; --结果 0005-11-13
--如果是字符的情况 --测试数据 CREATE VIEW V AS SELECT '1-12-20' AS DT1,'3-10-24' AS DT2 FROM DUAL; --语句 SELECT add_months(add_months((to_date(dt1,'yyyy-mm-dd')+to_char(to_date(dt2,'yyyy-mm-dd'),'dd')), to_char(to_date(dt2,'yyyy-mm-dd'),'mm')),3*12) from v; --结果 0005-11-13
CREATE VIEW V
AS
SELECT TO_DATE('1-12-20','YYYY-MM-DD') AS DT1,TO_DATE('3-10-24','YYYY-MM-DD') AS DT2 FROM DUAL;--执行语句
SELECT add_months(add_months((dt1+to_char(dt2,'dd')),to_char(dt2,'mm')),3*12) from v;
--结果
0005-11-13
--测试数据
CREATE VIEW V
AS
SELECT '1-12-20' AS DT1,'3-10-24' AS DT2 FROM DUAL;
--语句
SELECT add_months(add_months((to_date(dt1,'yyyy-mm-dd')+to_char(to_date(dt2,'yyyy-mm-dd'),'dd')),
to_char(to_date(dt2,'yyyy-mm-dd'),'mm')),3*12) from v;
--结果
0005-11-13
总天数: days_amount = ((add_months(&begin_date1,&years1 * 12 + &months1) + &day1) - &begin_date1)
+ ((add_months(&begin_date2,&years2 * 12 + &months2) + &day2) - &begin_date2);
要算出*年*月*天的格式需要写一个函数。