Re: search by date range
From: Jerry Gitomer <jgitomer_at_erols.com>
Date: Sun, 14 Nov 1999 00:05:35 -0500
Message-ID: <80lfr9$kbd$1_at_autumn.news.rcn.net>
Date: Sun, 14 Nov 1999 00:05:35 -0500
Message-ID: <80lfr9$kbd$1_at_autumn.news.rcn.net>
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 Sun Nov 14 1999 - 06:05:35 CET