lundi 4 avril 2016

How to get data between 2 dates in sql lite android?

I am trying to get date from date base in the range of two dates via using below query

SELECT * FROM TransactionLog WHERE TransactionDate > '2016-04-04' it is fetching data correctly but when I am including time along with date then it is not fetching data

SELECT * FROM TransactionLog WHERE TransactionDate > '2016-04-04 11:17:07' this is the query i am using for date and time. Is there a different way when time is included?

Aucun commentaire:

Enregistrer un commentaire