SQLite Order By Date1530019888000

sql sqlite android-sqlite sql-order-by
duncanportelli picture duncanportelli · Dec 30, 2012 · Viewed 82.7k times · Source

Every record in my SQLite database contains a field which contains a Date stored as a string in the format 'yyyy-MM-dd HH:mm:ss'.

Is it possible to query the database to get the record which contains the most recent date please?

Answer

Paritosh picture Paritosh · Dec 30, 2012

you can do it like this

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

Related questions

Android SQLite Query - Getting latest 10 records

I have a database saved in my Android application and want to retrieve the last 10 messages inserted into the DB. When I use: Select * from tblmessage DESC limit 10; it gives me the 10 messages but from the TOP. But I want …

Read More
GROUP_CONCAT in SQLite

I am having data like this 1 A 1 B 1 C 1 D 2 E 2 F 3 G 3 H 3 I 3 J 3 K by using this query select ABSTRACTS_ITEM._id,Name from ABSTRACTS_ITEM , ABSTRACT_AUTHOR , AUTHORS_ABSTRACT where ABSTRACTS_ITEM._id = AUTHORS_ABSTRACT.ABSTRACTSITEM_…

Read More
Select first row in each GROUP BY group?

As the title suggests, I'd like to select the first row of each set of rows grouped with a GROUP BY. Specifically, if I've got a purchases table that looks like this: SELECT * FROM purchases; My Output: id | customer | total …

Read More