Sort the date in database column of sqlite

Question

I am making an iPhone app. In this app i am using sqlite database for storing the dates in the column. enter image description here The date which I am storing in the database column is not in the sorting order as you can see in the image. Now I want to sort the date according to ascending order. How can I do this. Please provide me some solution.

Thanks in advance.

Did you define the column as a `date` to SQLite? SQLite knows how to sort dates if you simply tell it they're present. — Hot Licks, Aug 25 '11 at 11:33
check http://stackoverflow.com/questions/7161313/sort-the-date-in-sqlite-database — Narayanan Ramamoorthy, Aug 25 '11 at 11:33

score 0 · Answer 1 · answered Oct 14 '13 at 11:20

0

You need to store the datetime in timestamp format and then try to sort them.

answered Oct 14 '13 at 11:20

user2538944

305
4
12

Sort the date in database column of sqlite

1 Answers1