For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
hi how do i extract month for year 2019
select * from employeewhere month(hiredate) = 2and year = 2019
select * from employee
where month(hiredate) = 2
and year = 2019
am in database 11g