Re: Date question

From: <Lisa_Koivu_at_gelco.com>
Date: Tue, 20 Jun 2000 10:36:59 -0500
Message-Id: <10534.109862@fatcity.com>

Here you go. Is this what you are looking for?

  1 select oracle_date from date_dim
  2* where oracle_date between sysdate - 7 and sysdate
(DWPRD01.WORLD-SYSTEM)>/
ORACLE_DA

---

14-JUN-00
15-JUN-00
16-JUN-00
17-JUN-00
18-JUN-00
19-JUN-00
20-JUN-00

7 rows selected.

(DWPRD01.WORLD-SYSTEM)>
Kader Ben <kaderb_at_yahoo.com> on 06/20/2000 10:24:32 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Lisa Koivu/GELCO)

Subject: Date question

Good morning friends,

     Please how can I code a select query that return results of one week. For example between to day and last week.

TIA Ben

---

Do You Yahoo!?
Send instant messages with Yahoo! Messenger. http://im.yahoo.com/

--
Author: Kader Ben
  INET: kaderb_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Tue Jun 20 2000 - 10:36:59 CDT