I want to retrieve the date from sqlite by using date. But by default the column in sqlite inserted is datetime format.
For instance,this is my Type Table
_id date_value
1 2015-07-06T11:36:35
2 2015-07-06T12:10:10
3 2015-07-06T12:10:19
4 2015-07-03T17:13:59
5 2015-07-03T17:14:04
6 2015-07-03T17:14:27
I want to retrieve the data by using date only. How do i want to query?
I tried to retrieve like this: Select * from Type where date_value=date('2015-07-03T17:13:59') But it returns zero rows.
Expected result: _id date_value
4 2015-07-03T17:14:27
5 2015-07-03T17:14:04
6 2015-07-03T17:14:27
How should i achieve this output?
Aucun commentaire:
Enregistrer un commentaire