Years_Months_Days_Hours_Days

SELECT ID,REQUEST_REGISTERED_ON,RECTIFIED_ON,
TRUNC(MONTHS_BETWEEN(RECTIFIED_ON,REQUEST_REGISTERED_ON)/12) AS YEARS,
MOD(TRUNC(MONTHS_BETWEEN(RECTIFIED_ON,REQUEST_REGISTERED_ON)),12) AS MONTHS,
TRUNC(RECTIFIED_ON-ADD_MONTHS(REQUEST_REGISTERED_ON,TRUNC(MONTHS_BETWEEN(RECTIFIED_ON,REQUEST_REGISTERED_ON)))) AS DAYS,
trunc(RECTIFIED_ON - REQUEST_REGISTERED_ON)  as TOTAL_days,
trunc(((RECTIFIED_ON - REQUEST_REGISTERED_ON)-trunc(RECTIFIED_ON - REQUEST_REGISTERED_ON))*24)     AS "DIFF_IN_HOURS",
TRUNC(((((RECTIFIED_ON - REQUEST_REGISTERED_ON)-trunc(RECTIFIED_ON - REQUEST_REGISTERED_ON))*24)-
(trunc(((RECTIFIED_ON - REQUEST_REGISTERED_ON)-trunc(RECTIFIED_ON - REQUEST_REGISTERED_ON))*24)))*60)
 as DIFF_IN_MNTS
FROM NSC_USER.REQUEST_T  WHERE ID = ID AND RECORD_STATUS=1 ;