Re: date question

From: Ray Teale <ray_at_BLAHholly.com.au>
Date: Tue, 2 Apr 2002 13:31:54 +1000
Message-ID: <OC9q8.1042$l%4.100055@ozemail.com.au>

Oracle will default your year '-81' to 2081.

Try : - where hiredate between '20-FEB-1981' and '01-MAY-1981' or better still use the to_date function to make your date conversion explicit.

Ray

"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 Mon Apr 01 2002 - 21:31:54 CST