How to Calculate SUM in SQLite Android

Question

I am new to SQLite and Android. And wanted to calculate SUM of column1 when dates in column2 is selected.I am writing following function while receiving parameters fromDate and toDate in following function:

    int tot=0;
    SQLiteDatabase db=this.getWritableDatabase();
    String query= "SELECT SUM("+ COL_3+ ")" +" AS "+"Total"+" FROM "+TABLE_NAME+ " WHERE "+ COL_4+
             " BETWEEN "+ fromDate + " AND "+toDate+" ";
    Cursor cursor=db.rawQuery(query,null);
    if(cursor.moveToFirst()){
        tot=cursor.getInt(0);
    }
    return tot;

But this is giving tot value zero. What am I doing wrong here. Any help would be much appreciated.

Thanks in advance.

Show your declaration for COL_3, TABLE_NAME, fromDate, ... — Tung Tran
– Tung Tran, Commented Apr 2, 2018 at 16:08
public static final String COL_3="LIT"; public static final String TABLE_NAME="table1"; fromDate is String i am getting in function — Darshan Adakane
– Darshan Adakane, Commented Apr 5, 2018 at 13:57

Shalu T D · Accepted Answer · 2018-04-02 16:11:30Z

0

SQLLite requires dates to be in YYYY-MM-DD format. Since the data in your database and the string in your query isn't in that format, it is probably treating your "dates" as strings.

answered Apr 2, 2018 at 16:11

Shalu T D

4,0692 gold badges29 silver badges39 bronze badges

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

Collectives™ on Stack Overflow

How to Calculate SUM in SQLite Android

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