How to display those employees who joined the company before 15 of the month?
SELECT ename,hiredate FROM emp WHERE TO_CHAR(hiredate,’DD’)<15;