Query for retreive the users who are registered/created in last 24 hours in SQLite Android

String query24Hours = "SELECT * FROM " + DatabaseHandler.TABLE_USER +
                             " WHERE "+db_date+" >= datetime('now','-1 day')";

Above query will return all the records which are entered in last 24 hours.And make sure the column "db_date" in user table should be varchar.

Comments