Monday, 17 September 2012

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




select floor((trunc(sysdate)  - to_date('01-JAN-01'))/365)  years,
floor(mod((trunc(sysdate)- to_date('01-JAN-01')),365)/30 ) months ,
mod(mod((trunc(sysdate)- to_date('01-JAN-01')),365),30) days from dual;

No comments:

Post a Comment