Date interval: year, month, day, hour, minute, second, interval: Year

Date interval: year, month, day, hour, minute, second, interval: Year

Create a test table:

Create or replace view v ASSELECT TO_DATE ('1970-1-1 13:14:15 ', 'yyyy-MM-DD HH24: MI: ss') AS c from dual; SELECT * FROM v;

Subtract two dates to get the number of days, multiply by 24 to the hour, and so on. you can calculate the second. to calculate the month interval, use the months_between function.

The SQL code is as follows:

SELECT interval days, interval days * 24 AS interval hours, interval days * 24*60 AS interval minutes, interval days * 24*60*60 AS interval seconds, MONTHS_BETWEEN (SYSDATE, c) AS interval month, MONTHS_BETWEEN (SYSDATE, c)/24 AS interval year FROM (SELECT c, SYSDATE-c AS interval days FROM v );

The execution result is as follows: