Answered step by step
Verified Expert Solution
Question
1 Approved Answer
If hire_date stores the date an employee was hired, and birth_date the employee's date of birth, which of the following expressions is used in calculating
If hire_date stores the date an employee was hired, and birth_date the employee's date of birth, which of the following expressions is used in calculating the age (in years) the employee was when hired? A. TRUNC((hire_date - birth_date)/ 365.25) B. TRUNC(TO_YEAR(hire_date-birth_date)) C. hire_date-birth_date D. YEARS_BETWEEN(hire_date, birth_date)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started