SQLite Order By Date1530019888000

you can do it like this

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

sql sqlite android-sqlite sql-order-by

For me I had my query this way to solve my problem

select *  from Table order  by datetime(datetimeColumn) DESC LIMIT 1

Since I was storing it as datetime not date column

sql sqlite android-sqlite sql-order-by

When you sure the format of text field is yyyy-MM-dd HH:mm:ss (ex.: 2017-01-02 16:02:55), So It works for me simply:

SELECT * FROM Table ORDER BY dateColumn DESC Limit 1

Without any extra date function!

CodeHunter