android.database.sqlite.SQLiteException

near "11": syntax error (code 1): , while compiling: SELECT * FROM call_reminder WHERE reminder_date_time BETWEEN 21/05/2017 11:49:19 AND 14/05/2017 11:49:19

Solutions on the web1794

  • near "11": syntax error (code 1): , while compiling: SELECT * FROM call_reminder WHERE reminder_date_time BETWEEN 21/05/2017 11:49:19 AND 14/05/2017 11:49:19
  • near "16": syntax error (code 1): , while compiling: SELECT * FROM reminders WHERE reminder_date_time=2015-01-09 16:14
  • near "Nov": syntax error (code 1): , while compiling: SELECT * FROM Leads WHERE Wed Nov 16 00:00:00 GMT+05:30 2016 >=
  • Stack trace

    • android.database.sqlite.SQLiteException: near "11": syntax error (code 1): , while compiling: SELECT * FROM call_reminder WHERE reminder_date_time BETWEEN 21/05/2017 11:49:19 AND 14/05/2017 11:49:19 at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method) at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:887) at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:498)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Once, 2 weeks ago
    68 times, 6 days ago
    14 times, 3 weeks ago
    2 times, 1 month ago
    Unknown user
    Once, 2 months ago
    108 more bugmates