SQLite Order By Date1530019888000
you can do it like this
SELECT * FROM Table ORDER BY date(dateColumn) DESC Limit 1
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!
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