jeudi 28 avril 2016

What is the appropriate date formatting so the lexicographic ordering is the same as time ordering?

In my SQLite database, there is no Date datatype, so I have to store timestamps in text format.

Does the format yyyy-MM-dd HH:mm result in the correct ordering such that when you sort it lexicographically (by doing a normal sort ASC or DESC), it also orders by time value inherently?

Aucun commentaire:

Enregistrer un commentaire