How to display those employees who joined the company before 15 of the month?

Oracle Apps Interview Questions › Category: SQL › How to display those employees who joined the company before 15 of the month?
0 Vote Up Vote Down
Questions Master asked 9 years ago

How to display those employees who joined the company before 15 of the month?

1 Answers
0 Vote Up Vote Down
Shailender Thallam Staff answered 9 years ago

SELECT ename,hiredate FROM emp WHERE TO_CHAR(hiredate,’DD’)<15;