android sqlite 时间函数问题
使用android sqlite 出现一个奇怪的问题
下面是代码:
sqlGetId = "select * from " + The_TABLE_NAME + " where ( "
+ The_End_Time + "> date() ) and (" + The_Start_Time
+ "< date() )";
cursor = db.rawQuery(sqlGetId, null); Log.d(TAG, sqlGetId);
Log.d(TAG, "From sqlGetID find :" + Integer.toString(cursor.getCount())); cursor.close();
Cursor cursor2 = db.query(The_TABLE_NAME, null, null, null, null, null,
null);
Log.d(TAG, "In SQLITE =" + Integer.toString(cursor2.getCount()));
cursor2.moveToFirst();
int num = cursor2.getColumnIndex(The_End_Time);
Log.d(TAG, The_End_Time + " =" + cursor2.getString(num));
int snum = cursor2.getColumnIndex(The_Start_Time);
Log.d(TAG, The_Start_Time + "=" + cursor2.getString(snum));
从LogCat里面看到的回馈为:
select * from InputSubject where ( E_Time > date() ) and (S_Time <date())
From SqlGetId find: 0
In SQLITE =1
E_Time = 2011-8-30
S_Time = 2011-2-30
简单说明下就是:我查找想找到符合条件的数据 满足条件 E_Time 大于今天 S_Time 小于今天
我现在测试的时候数据库里面就放了这一个数据。明明满足条件。不过通过sql语句查询的时候找不出来。我就很奇怪了。谁能告诉我下问题出在哪里了?