How do I save and retrieve the date + time in the sqlite3 database?

advertisements

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.

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

Related Articles

How do I save and load the current time in java?

I need to be able to save and load the current time in java. I could use System.currentTimeMillis() to store it in a long, but I also need to be able to write it out in different formats, like; "yyyy-mm-dd", "dd/mm hour:min:sec", and s

I am unable to save and retrieve the image in iOS

I am unable to save and retrieve image in iOS. I am getting nil image trough this code: -(NSString *)saveImageDataWithImage:(UIImage *)image { NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentationDirectory,NSUserDomainMask, YES); NSStr

how to save images in the sqlite3 database?

I have an array of UIImages, how to I save them in sqlite3 database ?@Veer it is upto you you that how you want to save them to the Sqlite database as Parth told you before you have two options have a look on them below Saving images in the database

How to save and retrieve session data in the ID-code

I save some data in session on my verify controller then I extract this session data into user_activity model and insert session data into activity table. My problem is only username data saved in session and I can get and insert only username data a

How do I save and load the numpy.array () data correctly?

I wonder, how to save and load numpy.array data properly. Currently I'm using the numpy.savetxt() method. For example, if I got an array markers, which looks like this: I try to save it by the use of: numpy.savetxt('markers.txt', markers) In other sc

How do you save and load mixed data types?

I have couple of dozen pieces of data that I need to save and load on start of the application. They are int, String, long , array data types. I am confused that there seems to be so many ways to do this. It seems each variation has different methods

How do I save and retrieve a hashTable from a file?

I creating a program that will calculate something and store the information into a hashTable. What I want it to do is the next time it runs to restore the previous values stored in the hashTable and resume. So I ask how to save an object to a file?