Show Me Glossary
 

Using Date Functions

Previous previous|next Next Page

Sheila needs a report that displays the ages of the employee's dependents. She also wants to see how many years an employee has been with the company. Each employee is rewarded with a gift once their longevity with the company reaches 10 years.

She will need to use the SYSDATE and MONTHS_BETWEEN functions to determine this information.

Launch Demonstration

Show Me and Try It! - Use SQL Workshop to build Sheila's reports