First check the table to make sure it has rows between date range.
If it's true, chances are your original statement should work.
to_date function suggested by other answers should work as well.
I'll check the table first. I'll be interested to know the result.
- dxia
"Helen Pai" <hpya78_at_postoffice.pacbell.net> wrote in message
news:3CA6206C.D7F8CC05_at_postoffice.pacbell.net...
> 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 Thu Apr 04 2002 - 22:31:14 CST
