select all dates between two dates

Question

Hi How can we select all dates between from date and to date using sql? There are only 2 date fields in the tables such as from date and to date For example given the from date 03/1/2011 and the to date 03/5/2011 I want to return: 03/1/2011 03/2/2011 03/3/2011 03/4/2011 03/5/2011 My query is select intime as InDouttime as OutD from tbl_attendance where intime between '03/1/2011' and '03/5/2011' Result: 03/1/2011 03/2/2011 03/3/2011 03/4/2011 Any help would be highly appreciated.

Suthish Nair · Answer

Do you have rows of date 03/5/2011 in table?

Jaganathan Bantheswaran · Answer

Hi Just try like this select intime as InDouttime as OutD from tbl_attendance where intime > TO_DATE('03/1/2011' 'MM/DD/YYYY') and intime TO_DATE('03/05/2011' 'MM/DD/YYYY')

Vulpes · Answer

Hmm I wonder if there could be a non-zero time component to those dates in the database? Try this instead: select intime as InDouttime as OutD from tbl_attendance where intime >= '03/1/2011' and intime

Elizabeth Rani · Answer

Hi Thanks for the query but i have tried the sane query but this is also showing the same result. their is no change in the result. Is their any other way to retrieve the result. Any help would be highly appreciated.

Vulpes · Answer

Try: select intime as InDouttime as OutD from tbl_attendance where intime >= '03/1/2011' and intime