简单问题！

Question

select empno,ename,job from emp where job in ('CHEARK','MANAGER');
select empno,ename,job,hiredate from emp where hiredate between to_date('01-01-82','dd-mm-yyyy') and to_date('31-12-87','dd-mm-yyyy');

Answer 1

select empno,ename,job,hiredate from emp where trunc(hiredate) between to_date('01-01-82','dd-mm-yyyy') and to_date('31-12-87','dd-mm-yyyy');

Answer 2

select empno,name,job,hiredate
from emp
where to_char(hiredate,'yyyy-mm-dd') between '01-01-82' and '31-12-87';