CODEWITHSUNDEEP
objective-ciphone-sdk-3.0sqlitensdate
Rahul Vyas
Rahul Vyas

Reputation: 28750

how to save and retrieve date+time into sqlite3 database?

i want to save current date+time into database and also want to retrieve it. i know that in objective-C we cannot save date+time directly. i have double as a field into database and currently I'm saving date by converting it into double.

here is the method for converting date into double-

currentDate=[NSDate date];

startDate=(double)[currentDate timeIntervalSince1970];

now how do i retrieve date back from that double value? or is there another way to save dates in iPhone SDK.

Upvotes: 1

Views: 1291

Answers (2)

Williham Totland
Williham Totland

Reputation: 29039

Another alternative is to convert the date to ISO 8601 and save it as TEXT; this can be done using -description and -initWithString:. It will make the date slightly larger in the database; but it'll also be a lot more readable for debugging purposes.

Upvotes: 0

Louis Gerbarg
Louis Gerbarg

Reputation: 43462

NSDate *dateFromDouble(double interval) { 
  return [NSDate dateWithTimeIntervalSince1970: interval];
}

Upvotes: 2

Related Questions