Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> date question

date question

From: Helen Pai <hpya78_at_postoffice.pacbell.net>
Date: Sat, 30 Mar 2002 20:30:10 GMT
Message-ID: <3CA6206C.D7F8CC05@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 Sat Mar 30 2002 - 14:30:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US