Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2011
    Posts
    6

    Unanswered: years of service

    I have an employee table with hire_date and need to calculate years of service and include to_yminterval. not sure how to do this just in a select statement. then need to create a case statement ex. if years of service is > 10 '10 years of service

    thanks,
    capriman

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Try looking up examples of determining age. The logic is the same. We will give you pointers on Homework, but won't just do it. Sorry.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •