Hi,
I am trying to calculate the experience by subtracting current_date minus hiredate from emp table this way.
select * from emp where current_date - hiredate > 39;
However, this is returning all the records in the table irrespective of any value given.
I am not sure if the logic is correct or not but syntactically it isn't showing any error.
- Help me understand why is it returning all the records every time
- If above logic is invalid, Give me the correct query to fetch the records.
Table name: emp
!@mathguy