Prateek Prateek - 3 months ago 20
Android Question

Android/java Sqlite: How to retrieve max datetime?

Below is the snapshot of what I have got as a query from sqlite db.

After googling and reading a number of question around, I have come to know that to retrieve maximum datetime using aggregate functions like

is not possible as sqlite doesn't support much datatypes but treats datatype as

So, I have brought this data in a
or at
level. So how could I now get the maximum datetime from this list.

Is there any direct construct for this format in java. Or do we have something at sqlite level that I coudn't find.

Sqlite returned data


texts can be compared, sorted and ordered in SQLite.

Your format appears to be YYYY-MM-dd hh:mm:ss. Lucky for you, ordering this format result in ordering by date.


select current_test_id from someTable order by test_datetime desc limit 1


select current_test_id, max(test_datetime) from someTable

(or something, not entirely sure for the second one)