日期间隔之年、月、日、时、分、秒

CREATE OR REPLACE VIEW v AS
SELECT TO_DATE(‘2015-1-1 13:14:15‘, ‘YYYY-MM-DD HH24:MI:SS‘) AS c FROM DUAL;

SELECT * FROM v;

SELECT 间隔天数,
       间隔天数 * 24 AS 间隔小时,
       间隔天数 * 24 * 60 AS 间隔分,
       间隔天数 * 24 * 60 * 60 AS 间隔秒,
       MONTHS_BETWEEN(SYSDATE, c) AS 间隔月,
       MONTHS_BETWEEN(SYSDATE, c) / 24 AS 间隔年
  FROM (SELECT c, SYSDATE - c AS 间隔天数 FROM v);