Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: search by date range
As you can see it works.
1 SELECT empno, ename FROM emp
2* WHERE hiredate > '22-JAN-82'
QL> /
EMPNO ENAME
-------- ----------
7788 SCOTT
7876 ADAMS
7934 MILLER
regards
jerry gitomer
henry_atwork_at_my-deja.com wrote in message
<80l272$c37$1_at_nnrp1.deja.com>...
|will the following command work to find entries that are entered
after
|11/01/1999? select BLAH, BLAH, BLAH where date > '01-NOV-1999';
|
|if not how i can fix it? thanks.
|
|-hc
|
|
|Sent via Deja.com http://www.deja.com/
|Before you buy.
Received on Sat Nov 13 1999 - 23:05:35 CST