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 there any direct construct for this format in java. Or do we have something at sqlite level that I coudn't find.
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)