vendredi 6 mars 2015

compare part of inserted value and retrieve the values from the particular column in sqlite?


  • columnx

  • 1425795755580/0

  • 1425785965412/3



i have inserted milliseconds/noofdays in db in columnx.Now i want to retrieve that using the currenttime is equal to that milliseconds so for that i have written a query as follows.



SELECT substr(reminder,0,14) from tablename where substr(reminder,0,14)='1425795755580'



..but i'm unable to get the value can anyone help me to solve this.



Aucun commentaire:

Enregistrer un commentaire