mercredi 8 juillet 2015

Retrieve SQLite Data by using Date part out of DateTime Format

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