我有一个sqlite3的数据库表中包含姓名，地址，出生细节了日期要显示1990-01-01至1995-01-01详细信息。

I have a Sqlite3 database table contains name,address,date of birth details.i want to display 1990-01-01 to 1995-01-01 details.

但sqlite3的数据库存储只有以下数据类型。

but Sqlite3 database stores only following data types.

TEXT
NUMERIC
INTEGER
REAL
NONE

任何一个有一些暗示来存储和检索日期格式数据..？

Any one have some hint to store and retrieve date format data..?

推荐答案

使用这种code到您的日期转换成毫秒的格式，并将其存储到数据库中的整数类型

Use this code to convert your date into millisecond format and store it into your database as 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（） - 给毫秒的格式

date.getTime()-give the millisecond format

在以同样的方式到你的输入转换（即从1990-01-01到今天为止1995-01-01）

At the same way to convert your input (i.e from 1990-01-01 and to 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 from database using following query

db.rawQuery("SELECT * FROM table_name WHERE column_name BETWEEN "+value1+" AND "+value2+"",null);

or 

db.rawQuery("SELECT * FROM table_name WHERE column_name<="+value1+" AND column_name>="+value2+"",null);