Using Date Functions
Sheila needs a report that displays the ages of the employees' dependents. She also wants to see how many years an employee has been with the company. Each employee is rewarded with a gift when longevity with the company reaches 10 years.
She needs to use the SYSDATE and MONTHS_BETWEEN functions to determine this information.
 |