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 ...
-- We create functions so we can call them instead of duplication the tasks over and over --Sql has already many useful predifined functions so in this module we are only going to learn them ...