var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Elapsed Days as Years, Months and Days
I know how to track the duration of time lapsed between two date using Excel that one has to use the DATEDIF worksheet function, but I got no clue on how to it in Oracle. This is how far I go.
SELECT LAST_NAME, TRUNC((SYSDATE - HIRE_DATE)/365)
TRUNC((SYSDATE - HIRE_DATE)/12)
ORDER BY "Years" DESC;
Any one with a clue?
SELECT LAST_NAME, months_between(tRUNC(SYSDATE ),HIRE_DATE)/12 "Years",
months_between(tRUNC(SYSDATE ),HIRE_DATE) "Months"
ORDER BY 2 DESC;
You do not need a parachute to skydive. You only need a parachute to skydive twice.