Prob with Date to split month wise

[jagadish]

I have two date columns in one table
D1,D2 and other columns V3,V4 from this i want to display the data month wise, Week wise,Quater wise, day wise...
So how can i go about this..

Use will give the input values for D1 and D2...
D1 = 01-jan-2001,D2 = 31 -jan-2001
if this is the input , i have to display the result for one month only ...if not 22-jan-03 , 05-feb-2003..
i have to display for two months, as the dates fall in two months.

Please advise me on this ASAP

[david_b_fowler]

Try using LAST_DAY function for each date and do between if amount of d2-d1 is greater than 1.

Look at Oracle SQL manual for date math other capabilities