Re: Date question

Thanks Lisa,

    Exactly this is what I look for.
Many thanks again.

Ben

• Lisa_Koivu_at_gelco.com wrote:
  > 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)
  >
  >
  >
  >
  > 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).
  >
  >
  >
  >
  >
  >
  > --
  > Author:
  > INET: Lisa_Koivu_at_gelco.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).
  

  ---