How to select data between two dates from sqlite db in dd-mm-yyyy format?
use :
select * from tbl_name where Attribute_name between 'yyyy-mm-dd' and 'yyyy-mm-dd';here Attribute_name is date_time column name
example :
select * from tbl_node where mydate between '2014-02-02' and '2014-02-06';1|1|123|456|12eb-ab|1|1|254|123|19|2014-02-03 16:00:442|1|123|456|12eb-ab|1|1|254|123|19|2014-02-03 16:01:033|1|123|456|12eb-ab|1|1|254|123|19|2014-02-03 16:00:57