select round((sysdate - Hire_date)/30,2) as Months from employees; select first_name,round((sysdate - Hire_date)/7,0) as Weeks from employees; -- no Fractions -- Using Trunc fucntions select ...