CODEWITHSUNDEEP
iphone
Minkle Garg
Minkle Garg

Reputation: 751

Sort the date in Sqlite database

I am making an iPhone application in which I am storing date and time in a column now I want to sort the date and time in the order which occurs first.

How can I do this? please give me some solutions.

Upvotes: 1

Views: 2339

Answers (2)

rckoenes
rckoenes

Reputation: 69489

Save the NSDate as NSTimeInterval:

NSTimeInterval timeInterval = [[NSDate date] timeIntervalSince1970];

The NSTimeInterval is just a double which you can save in the a SQLite database.

With an simple SQL query you can then select the sort then:

SELECT * FROM dateTable ORDER BY myDateColumn DESC

And to get the NSDate back just:

NSDate *date = [NSDate dateWithTimeIntervalSince1970:databaseTimeInterval];

Upvotes: 3

fncap
fncap

Reputation: 126

Have you tried this

SELECT * FROM TableName WHERE DateColumn >= date('now') ORDER BY DateColumn ASC

Upvotes: 1

Related Questions