ORACLE SQL Tutorial to get Years of Experience

Опубликовано: 29 Апрель 2026
на канале: Ganesh Anbarasu

11,338

138

In this video, we will see how add_months, months_between can be used to get Years of work experience for an employee. SQL used in this video are given below.

select add_months(sysdate,2) from dual;

select months_between(sysdate,to_date('22082016','ddmmyyyy') ) from dual;
select trunc(months_between(sysdate,to_date('22082016','ddmmyyyy') )) from dual;

select mod(16,12) from dual;

select * from employees;

SELECT first_name,hire_date, trunc(months_between(SYSDATE,hire_date)) mnths_between
from employees;

12 months = 1 year

SELECT first_name,hire_date, trunc(months_between(SYSDATE,hire_date)) mnths_between,
trunc(months_between(SYSDATE,hire_date)/12) years,
trunc(months_between(SYSDATE,hire_date)) - trunc(months_between(SYSDATE,hire_date)/12)*12 No_of_Months
from employees;

SELECT hire_date,add_months(hire_date,trunc(months_between(SYSDATE,hire_date))) new_date from employees;

SELECT hire_date,
trunc(sysdate) - add_months(hire_date,trunc(months_between(SYSDATE,hire_date))) no_of_days from employees;

SELECT first_name,hire_date, trunc(months_between(SYSDATE,hire_date)) mnths_between,
trunc(months_between(SYSDATE,hire_date)/12) years,
trunc(months_between(SYSDATE,hire_date)) - trunc(months_between(SYSDATE,hire_date)/12)*12 No_of_Months,
trunc(sysdate) - add_months(hire_date,trunc(months_between(SYSDATE,hire_date))) no_of_days
from employees;