java - how to insert data type date(yyyy-MM-dd) in sqlite database and retrive data between two dates in android -

i have sqlite3 database table contains name,address,date of birth details.i want display 1990-01-01 1995-01-01 details.

but sqlite3 database stores following data types.

text numeric integer real none 

any 1 have hint store , retrieve date format data..?

use code convert date millisecond format , store database integer types

string somedate = "1995-01-01"; simpledateformat sdf = new simpledateformat("yyyy-mm-dd"); date date = sdf.parse(somedate); system.out.println(date.gettime()); 

date.gettime()-give millisecond format

at same way convert input (i.e 1990-01-01 , date 1995-01-01)

simpledateformat sdf = new simpledateformat("yyyy-mm-dd");     date date1 = sdf.parse(1990-01-01);     value1=date.gettime(); date date2 = sdf.parse(1995-01-01);     value2=date.gettime(); 

retrieve database using following query

db.rawquery("select * table_name column_name between "+value1+" , "+value2+"",null);  or   db.rawquery("select * table_name column_name<="+value1+" , column_name>="+value2+"",null);