Android : how to select some rows of specific date

on Saturday, August 16, 2014


i using sqlite datebase i want to select some rows of specific date. where i am using e_date as text


CREATE TABLE expenses ( id integer PRIMARY KEY AUTOINCREMENT, e_type text NOT NULL, e_date text NOT NULL, e_amt text NOT NULL, e_method text NOT NULL, desc text );


where i am trying to select using query


select * from expenses where e_date between 31/7/2014 and 15/8/2014;


but its not working help me out..


0 comments:

Post a Comment