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
Don't listen to anybody. Check how is environment variable
NLS_DATE_FORMAT set. It should be DD-MON-RR for your statement to work
right. If not sure, use to_date function with above mentioned format
mask.
Received on Tue Apr 02 2002 - 14:13:10 CST
