Re: Newbie SQL Question

trunc(sysdate -doh, 'YYYY')

Hth,

Sybrand Bakker, Oracle DBA

Uzmati29 <uzmati29_at_aol.com> wrote in message news:20000312183617.02585.00001733_at_ng-fq1.aol.com...
> Hi,
>
> I am new to oracle and need some help with SQL statements. I am using SQL
+
> 3.3.
>
> How would I perform this querry?
>
> ----------------------------
> For mechanics, list the employee ID number, last names, salary, years of
> experience, and the aircraft that they are certified to repair?
> ----------------------------
>
> The tables involved are
>
> Employee (E_ID; Lname; Fname; MI; Address; DOH; Salary; Base; Category;
> Year_of_Birth)
>
> Mech-attrib (E_ID, Can_Repair)
> ----------------------------
>
> My main problem involves the years of experience. How do I use the date
of
> hire (DOH) with the sysdate function to calculate an employee's years of
> experience?
>
>
> thanks
Received on Mon Mar 13 2000 - 00:46:15 CST