How to display those employee who joined in the company in the month of Dec?

Oracle Apps Interview Questions › Category: SQL › How to display those employee who joined in the company in the month of Dec?
0 Vote Up Vote Down
Questions Master asked 10 years ago

How to display those employee who joined in the company in the month of Dec?

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

SELECT ename,hiredate FROM emp WHERE TO_CHAR(hiredate,’MON’)=’DEC’;