How do I get the newest time value in Android Java SQL in my database?

Question

I have an SQL database with two columns "Message" and "Datetime". I want to know when the last entry was added. I want to get the highest datetime value.

What the most efficient way to query the database in Android/Java to get this value?

Please see if this can help: http://stackoverflow.com/questions/9902394/how-to-get-last-record-from-sqlite — sAm, Sep 07 '16 at 12:18
Are you using SQLite? What is the type of the column for "Datetime"? Some code would be useful? — Balkrishna Rawool, Sep 07 '16 at 12:18

Balkrishna Rawool · Accepted Answer · 2016-09-07T13:05:50.963

3

Assuming you have SQLite:

If your column is TEXT or REAL then this will give you newest item:

SELECT * FROM Table ORDER BY date(column) DESC Limit 1

or

SELECT * FROM Table ORDER BY datetime(column) DESC Limit 1

or simply

SELECT * FROM Table ORDER BY column DESC Limit 1

edited Sep 07 '16 at 13:05

answered Sep 07 '16 at 12:25

Balkrishna Rawool

1,865
3
21
35

1

You don't need to call `date()` or `datetime()` for this. – CL. Sep 07 '16 at 12:58

How do I get the newest time value in Android Java SQL in my database?

1 Answers1