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

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.