How to display "Experience of employee"?e.g. 3 years 4 months 19 days

Interview Candidate
Aug 1st, 2006
3
9510

First
Prev
Next
Last

Showing Answers 1 - 3 of 3 Answers

jamesravid
Profile Answers by jamesravid

Dec 10th, 2006

Try this query
select trunc(sysdate) today, hiredate, to_char(trunc(months_between(sysdate,hiredate)/12)) || ' years ' || to_char(mod(trunc(months_between(sysdate,hiredate)),12)) || ' months ' || to_char(trunc(sysdate) -add_months(hiredate,trunc(months_between(sysdate,hiredate)))) || ' days' "Experience" from emp;