Retrieve data between two dates in Android SQLite

Question

I want to retrieve data between two dates in Android SQLite I used one function in SQLiteAdapter class. My function is

public void history(String startdate,String enddate) {  
   Cursor mCursor = db.rawQuery("SELECT * FROM "+ KK_AIRLINEBOOK + 
                    " WHERE " + KEY_Bookingdate + 
                    " BETWEEN " + startdate + " AND " + enddate , null);        
}

However it doesn't work it shows syntax error near AND

What is the exact query you are sending to the database? Please edit it into your question. (Also, please use the code button for code formatting in the future - see my edit). — halfer
– halfer, Commented Mar 31, 2013 at 12:01
@halfer actuly i want to show booking history to user like if user want to know his booking details between particular two dates........what query i need to pass??? please please help me :( :( — Pooja
– Pooja, Commented Mar 31, 2013 at 12:28

Hoan Nguyen · Accepted Answer · 2013-03-31 15:24:00Z

16

Put literals

public void history(String startdate,String enddate) {  
Cursor mCursor = db.rawQuery("SELECT * FROM "+ KK_AIRLINEBOOK + 
                " WHERE " + KEY_Bookingdate + 
                " BETWEEN '" + startdate + "' AND '" + enddate + "'", null);        
}

However it is better if you use selectionArgs

public void history(String startdate,String enddate) {  
Cursor mCursor = db.rawQuery("SELECT * FROM "+ KK_AIRLINEBOOK + 
                " WHERE " + KEY_Bookingdate + 
                " BETWEEN ?  AND ?", new String[]{startdate, enddate});        
}

answered Mar 31, 2013 at 15:24

Hoan Nguyen

18.2k3 gold badges52 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Retrieve data between two dates in Android SQLite

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related