mercredi 27 janvier 2016

compare date from sqlite with selected date by user in java

please help me. i want to retrieve all data from sqlite database where date(in database) is equal to date(user select) in java. So far, this is my code.

String sql= "select * from " + DatabaseHelper.table1_name + " where " + DatabaseHelper.date + " like '"+ dateinput +"'";

for example dateinput is 1.1.2016. In sqlite database, i have data at 1.1.2016, but it does not displayed. Please help me.

Aucun commentaire:

Enregistrer un commentaire