select all dates between two dates

Elizabeth Rani

15y3.1k

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 InD,outtime 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.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair15y ago
Do you have rows of date 03/5/2011 in table?
0
Jaganathan Bantheswaran15y ago
Hi,

Just try like this

select intime as InD,outtime 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')
0
Vulpes15y ago
Hmm, I wonder if there could be a non-zero time component to those dates in the database?

Try this instead:

select intime as InD,outtime as OutD from tbl_attendance where intime >= '03/1/2011' and intime < '03/6/2011'
0
Elizabeth Rani15y ago
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.
0
Vulpes15y ago
Try:

select intime as InD,outtime as OutD from tbl_attendance where intime >= '03/1/2011' and intime <= '03/5/2011'
0