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 ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results