SELECT ename, sysdate "S-date",hiredate "hdate", round(months_between(sysdate,hiredate),2)"months", round(months_between(sysdate,hiredate)/12,2)"y-in-job" , round(months_between(sysdate,hiredate)* (365/12),0)"days" FROM emp where rownum < 7

POSTGRESQL:

select ename, current_date "c-date",hiredate,age(hiredate)"y-in-job" ,date_part('days', now() - HIREDATE) as days from emp LIMIT 6