Re: date question

assuming you have data in that range, then rewrite you query: select ename,job,hiredate from emp where hiredate between to_date('20-FEB-81','DD-MON-RR') and to_date('01-MAY-81','DD-MON-RR');

Helen Pai wrote:
>
> Hello,
>
> why my hiredate didn't show anything?
>
> SQL> select ename, job, hiredate
> 2 from emp
> 3 where hiredate between '20-FEB-81' and '01-MAY-81';
>
> no rows selected
Received on Sat Mar 30 2002 - 14:52:36 CST