Dates between the two given dates

[pointers]

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.

[debasisdas]

You need to use BETWEEN clause .

[BMantri]

Hello,
You can use col > to_date(date1, 'dd-mon-yyyy') and col <= to_date(date2,' dd-mon-yyyy') in the WHERE clause