Question

查询emp表中入职时间(hiredate)在今年内的所有员工信息，sql应该怎么写

Answer 1

select * from emp where to_cahr(hiredate,'YYYY') = to_char(sysdate,'YYYY')

Answer 2

select * fro emp where year(hiredate)=year(getdate())