SQL question....

From: VS <slootsky_at_erols.com>
Date: 2000/03/23
Message-ID: <38DA933C.B16A1AE7@erols.com>#1/1

Schema: SCOTT
8.0.5 or 8.1.5 environment

WHY THIS GOING ON ?!!!! SQL> select ename, job,hiredate
  2 from emp
  3 where hiredate between
  4 to_date ('20-FEB-81') AND
  5 to_date ('01-MAY-81')
  6 ORDER BY hiredate
  7 /

no rows selected

SQL> select ename, job,hiredate
  2 from emp
  3 where hiredate between
  4 to_date ('20-FEB-1981', 'DD-MM-YYYY') AND   5 to_date ('01-MAY-1981', 'DD-MM-YYYY')   6 ORDER BY hiredate
  7 /

ENAME JOB HIREDATE

---------- --------- ---------
ALLEN      SALESMAN  20-FEB-81
WARD       SALESMAN  22-FEB-81
JONES      MANAGER   02-APR-81
BLAKE      MANAGER   01-MAY-81

SQL> spool off Received on Thu Mar 23 2000 - 00:00:00 CST