How can get all dates between two dates in sqlite?

Question

date from : 2014-05-01
date to : 2014-05-06

Results in rows :

2014-05-01
2014-05-02
2014-05-03
2014-05-04
2014-05-05
2014-05-06

Found same scenario but it has been done in MySQL. here

Thanks!

What's the problem with that approach? Also, why do you need to do it in SQL - a general-purpose programming language is likely better for such work. — laalto, May 17 '14 at 06:26

score 0 · Answer 1 · answered May 17 '14 at 06:19

0

can try this:

SELECT * FROM tbl where Date between fromDate and toDate

give your required value to fromDate and toDate parameters.

answered May 17 '14 at 06:19

Dig

kablu · Answer 2 · 2014-05-17T07:21:36.487

-1

you can try like this.

SELECT * FROM table WHERE  datecol  BETWEEN '2014-05-01' AND '2014-05-06'

edited May 17 '14 at 07:21

answered May 17 '14 at 06:54

kablu

2 Answers2