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