Storing date from date picker in to sqlite DB as DATETIME type

mini998 · 01-12-2012, 10:40 AM

I have date picker called 'dob' in my view , and in my sqlite table I have a column named DOB as DATETIME type.

When I try to save data to sqlite DB like below I get an error saying

Code:

Unhandled parameter type: __NSDate

Code:

 NSDictionary *player =[[NSDictionary alloc] initWithObjectsAndKeys: 
                           firstName.text,@"FirstName",
                           middleName.text,@"MiddleName",
                           familyName.text,@"Familyname",
                           dob.date,@"DOB",

Do I have to format the value from date picker before storing in DB?

cheers

Duncan C · 01-12-2012, 11:22 AM

Quote:

Originally Posted by mini998

I have date picker called 'dob' in my view , and in my sqlite table I have a column named DOB as DATETIME type.

When I try to save data to sqlite DB like below I get an error saying

Code:

Unhandled parameter type: __NSDate

Code:

 NSDictionary *player =[[NSDictionary alloc] initWithObjectsAndKeys: 
                           firstName.text,@"FirstName",
                           middleName.text,@"MiddleName",
                           familyName.text,@"Familyname",
                           dob.date,@"DOB",

Do I have to format the value from date picker before storing in DB?

cheers

Depends on your needs. You can convert your date to a double precision floating point number very easily. That gives you very fast sorting, as well as fast calculation of the time span between dates. That gives you sub-millisecond accuracy. You could probably also cast the values to floats to make them smaller for storage, with a slight loss of accuracy.

NSDate has a method timeIntervalSinceReferenceDate that lets you convert dates to a double, and another method that lets you convert those values into dates.

If you just need month/day/year, you can build a date string and save that, using a date formatter, or write your own code using NSCalendar and NSDateComponents.

mini998 · 01-12-2012, 12:02 PM

Thanks duncan

I used this instead

Code:

    
    NSDictionary *player =[[NSDictionary alloc] initWithObjectsAndKeys: 
                           firstName.text,@"FirstName",
                           middleName.text,@"MiddleName",
                           familyName.text,@"Familyname",
                           [dob.date timeIntervalSince1970],@"DOB",nil];

now it throws an exception , and point to the last line .when I comment that line program works fine

Code:

*** Terminating app due to uncaught exception 'NSInvalidArgumentException', reason:
 '-[__NSPlaceholderDictionary initWithObjectsAndKeys:]:
 second object of each pair must be non-nil.  Or, did you forget to nil-terminate your parameter list?'

cheers

Duncan C · 01-12-2012, 01:30 PM

Quote:

Originally Posted by mini998

Thanks duncan

I used this instead

Code:

    
    NSDictionary *player =[[NSDictionary alloc] initWithObjectsAndKeys: 
                           firstName.text,@"FirstName",
                           middleName.text,@"MiddleName",
                           familyName.text,@"Familyname",
                           [dob.date timeIntervalSince1970],@"DOB",nil];

now it throws an exception , and point to the last line .when I comment that line program works fine

Code:

*** Terminating app due to uncaught exception 'NSInvalidArgumentException', reason:
 '-[__NSPlaceholderDictionary initWithObjectsAndKeys:]:
 second object of each pair must be non-nil.  Or, did you forget to nil-terminate your parameter list?'

cheers

The NSDate method timeIntervalSince1970 returns a double, which is a scalar data type, not an object.

You can only add objects to dictionaries.

You need to convert your value to an NSNumber object if you want to save it in a dictionary:

Code:

    
    NSDictionary *player =[[NSDictionary alloc] initWithObjectsAndKeys: 
                           firstName.text,@"FirstName",
                           middleName.text,@"MiddleName",
                           familyName.text,@"Familyname",
                           [NSNumber numberWithDouble: [dob.date timeIntervalSince1970],@"DOB",nil];

mini998 · 01-12-2012, 05:39 PM

Thanks duncan ,I used this and it worked

Code:

[NSString stringWithFormat:@"%f", [dob.date timeIntervalSince1970]],@"DOB",

Duncan C · 01-12-2012, 09:32 PM

Quote:

Originally Posted by mini998

Thanks duncan ,I used this and it worked

Code:

[NSString stringWithFormat:@"%f", [dob.date timeIntervalSince1970]],@"DOB",

Use NSNumber to save numbers, not NSString. NSNumber saves the exact value, efficiently, and can be sorted, indexed, etc.