Date interval year, month, day, time, minute, second

Original: date interval of the year, month, day, time, minute, second

To create a test table:

CREATE OR REPLACE VIEW v asselect to_date (' 2015-1-1 13:14:15 ', ' yyyy-mm-dd HH24:MI:SS ') as C from DUAL; SELECT * from V;

Two date subtraction, get the number of days, multiplied by 24 is the hour, and so on, you can calculate the second, if you want to calculate the month interval, you need to use the function Months_between.

The SQL code is as follows:

SELECT interval days, number of days * as interval, number of days between * as       interval, interval of days *, every       second,       Months_between (Sysdate, c) as interval month,       months_between (Sysdate, c)/year interval from  (SELECT C, sysdate-c as interval days from V);

The results of the implementation are as follows:

Date interval year, month, day, time, minute, second