[Solved] My application is crashing while retrieving task, date and displaying on ListView using SQLite database [duplicate]

Question

You can use a text datatype to store dates within SQLite while table creation.

Storing dates in UTC format, the default if you use datetime(‘now’) (yyyy-MM-dd HH:mm:ss) will then allow sorting by the date column.

Retrieving dates as strings from SQLite table you can then convert them as required into formats using the Calendar or the DateUtils.formatDateTime method.

Accepted Answer

You can use a text datatype to store dates within SQLite while table creation.

Storing dates in UTC format, the default if you use datetime(‘now’) (yyyy-MM-dd HH:mm:ss) will then allow sorting by the date column.

Retrieving dates as strings from SQLite table you can then convert them as required into formats using the Calendar or the DateUtils.formatDateTime method.