Dates between the two given dates

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 423,751 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,315 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Oracle advertiser: Programming Forums

Thread Tools Display Modes

Views: 985 | Replies: 4

•

Join Date: Oct 2006

Posts: 34

Reputation: pointers is an unknown quantity at this point

Rep Power: 2

Solved Threads: 1

pointers

Offline

Light Poster

Dates between the two given dates

Apr 21st, 2008

Hi,

Can we get a SQL query, to display all the dates between two given dates
eg. if date1=21-mar-2007 and date2=25-mar-2007
then the query should display all the dates between those two given dates i.e
22-mar-2007, 22-mar-2007, 23-mar-2007and 24-mar-2007.

Query should not contain any plsql coding.

Regards.

•

Join Date: Feb 2007

Location: Bangalore,India

Posts: 1,270

Reputation: debasisdas is on a distinguished road

Rep Power: 4

Solved Threads: 80

debasisdas debasisdas is offline

Offline

Nearly a Posting Virtuoso

Re: Dates between the two given dates

Apr 21st, 2008

You need to use BETWEEN clause .

Share your Knowledge.

•

Join Date: Nov 2007

Posts: 51

Reputation: Nige Ridd is an unknown quantity at this point

Rep Power: 1

Solved Threads: 9

Nige Ridd

Offline

Junior Poster in Training

Re: Dates between the two given dates

Apr 22nd, 2008

You could try something like

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
SELECT date1 + rownum
    FROM all_objects
    WHERE rownum < date2 - date1;
select date1 + rownum
    from all_objects
    where rownum < date2 - date1;

Nige

Last edited by peter_budo : Apr 23rd, 2008 at 7:00 pm. Reason: Keep It Organized - please use [code] tags

•

Join Date: Oct 2006

Posts: 34

Reputation: pointers is an unknown quantity at this point

Rep Power: 2

Solved Threads: 1

pointers

Offline

Light Poster

Re: Dates between the two given dates

Apr 23rd, 2008

I tried but dint get.....if u can pls help me out...

•

Join Date: Nov 2007

Posts: 51

Reputation: Nige Ridd is an unknown quantity at this point

Rep Power: 1

Solved Threads: 9

Nige Ridd

Offline

Junior Poster in Training

Re: Dates between the two given dates

Apr 23rd, 2008

How are you trying to run it? If you are using strings for the values of date1 & date2 then you'll have to put to_date() round each one as it uses the date arithmetic features in Oracle.
Nige