mercredi 15 avril 2015

Sqlite sorting by date column

I am storing date in ISO8601 format example 2015-04-15T10:54:14Z in sqlite table, I want youngest date from table. below are the dates in my sqlite table



2015-04-15T10:54:14Z
2015-04-15T10:54:115Z
2015-04-15T10:54:216Z
2015-04-15T10:54:320Z
2015-04-15T10:54:422Z


I am trying below query:



SELECT * FROM Table1 ORDER BY datetime("date_column") DESC ;


but I am not getting appropriate result.


Aucun commentaire:

Enregistrer un commentaire