Sorting a table by Date SQlite

Question

I have a table with 3 columns.(Id-Primary Key, Task-string, due date-string). i want to insert task and set due date. Then, i want to display them in list view.Before i display them in list view, i want this table sorted based on date from most recent to least.

`I know how to sort just a column, but i want to sort entire table` what does this mean? Simply retrieve the whole table and sort it on the date column. — Phantômaxx, Feb 24 '17 at 17:15
Possible duplicate of [SQLite Order By Date](http://stackoverflow.com/questions/14091183/sqlite-order-by-date) — Hywel Rees, Feb 24 '17 at 17:53

score 0 · Answer 1 · edited Feb 24 '17 at 17:12

0

Cursor cursor = db.query(DATABASEHelper.DATABASE_TABLE,
result_columns, where,
whereArgs, groupBy, having, order);

so argument order will be "COLUMN_NAME ASC"

edited Feb 24 '17 at 17:12

Gurwinder Singh

38,557
6
51
76

answered Feb 24 '17 at 17:12

Elsunhoty

1,609
14
27

Sorting a table by Date SQlite

1 Answers1