- 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