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 -> A tricky sql date question

A tricky sql date question

From: <seanfour_at_my-deja.com>
Date: Tue, 21 Nov 2000 14:37:25 GMT
Message-ID: <8ve1b5$h64$1@nnrp1.deja.com> 






Is there any way I can list the dates of all the days between 2 dates
without looping through a select statement from dual? Basically I want
to be able to give it, say '01-AUG-2001' and '01-AUG-2002' and have it
spit back all of the dates between without having to hit the DB 365
times to do it.  Thanks for any help!!




Sent via Deja.com http://www.deja.com/


Before you buy.
Received on Tue Nov 21 2000 - 08:37:25 CST












Original text of this message













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