LIST between DATES!

[steenie]

Hi!
I want a query to list dates between two given dates.

Thank you!

[vbaskar]

Hi

Select , from

where
betweeen and

[vbaskar]

Hi

Select col1,col2 from
tablename
where
datecol betweeen date1 and date2

[Pinakin]

Plz give more details. Do you want to display all dates stored in your database and that are falling between given two dates ??? or just want to get dates between two dates (as in calender) ???

[sree_sri]

This query will give you the emp names who joined between
Mar 01 to Mar 31.

select emp_name from employee
where date_of_joined between '01-MAR-01' AND '31-MAR-01';

Hope it will work, If not give us some more details like
what table,column,critiria...etc. Good Luck

[jmodic]

If you want to list all the dates between two given dates (start_date and end_date) )then try the following:

SELECT start_date - 1 + ROWNUM
FROM all_objects
WHERE ROWNUM <= end_date - start_date;

[steenie]

Hi!
I want to show dates between two given dates. This using "dual" table.

[jmodic]

Why do you want to stick with dual? Dual has only one row, so it can return you only one date. You need a table or view that has at least so many rows as the dates you want to display. So what is wrong with the sollution with ALL_OBJECTS (or some similar publicly accesible view/table)? It is accesible to every user, the same way the DUAL.

[Sadiq106]

I want to list all the dates between two given dates (start_date and end_date)

where start_date = minimum date from a table
and end_date = sysdate

can u please guide for generating query for this

[ebrian]

So you reply to an 8 yr old thread??

What have you tried?