date calculation - URGENT, PLEASE!

[Jerod]

Hi all!
I have a table let's say emp table,
a field on the emp table called ename and a hiredate.
The ename is varchar2, and hiredate is date.
I want to know how long an employee has worked for a company.
I need my output to read:
Ename Years Months
Jeff 16 1 etc.
Can you please help me with the syntax?
Thank you!
Jerod

 

[THoey]

The following SQL works:

SQLWKS> select trunc(months_between(trunc(sysdate),to_date('07-DEC-1963', 'DD-MON-YYYY'))/12) as age,
2> trunc(MOD(months_between(trunc(sysdate),to_date('07-DEC-1963', 'DD-MON-YYYY')), 12)) as months
3> from dual
4>
AGE MONTHS
---------- ----------
37 7
1 row selected.
Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.

 

[Jerod]

Thank you Terry!
I modified it to meet my needs.
Thanks a bunch!
Jerod