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

Home -> Community -> Usenet -> c.d.o.server -> Re: search by date range

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@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 Sat Nov 13 1999 - 23:05:35 CST

Original text of this message

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