How to save date in sqlite tables?

Question

I can save DATE with core data and all operation is working fine.

I can not save DATE as string as my fetch request will have filters on a DATE column.

Sqlite has a support of DateTime datatype but unfortunately, I can't save my IOS current dateTime. Any Suggestion?

see this http://stackoverflow.com/questions/22115571/sqlite-storing-retrieving-and-comparing-a-datetime-field — Anbu.Karthik, Feb 15 '17 at 12:31
see this http://stackoverflow.com/questions/302664/objective-c-and-sqlites-datetime-type — Anbu.Karthik, Feb 15 '17 at 12:31
can you be more specific to why you can't save current `dateTime` ? Some code snippets maybe? — ystack, Feb 15 '17 at 12:50
Above link will not help me as I can't save the date as a string. Sorry. — Kanjariya-IOS, Feb 15 '17 at 13:05
@yStack, with my insert query I'm trying to save Date as blob and some other type but is setting null... — Kanjariya-IOS, Feb 15 '17 at 13:08
see this https://behestee.com/2011/08/18/objective-c-and-sqlites-datetime-type/ — Anbu.Karthik, Feb 15 '17 at 13:34
@Anbu.Karthik, the above link is not what I want... they are converting it to a string. So with string, I can not apply date operations. — Kanjariya-IOS, Feb 16 '17 at 06:14
I need something like sqlite3_bind_int64 which can save DateTime or timestamp. Hope this makes clear. Thanks — Kanjariya-IOS, Feb 16 '17 at 06:18
If I convert it to a string then we won't be able to apply date comparison condition by expecting it will do an operation on a date as it will consider it as a string. Anyway thank you for all your support. I will update here once I do it — Kanjariya-IOS, Feb 16 '17 at 08:32

score 0 · Answer 1 · answered Feb 15 '17 at 13:53

Convert the NSDate into a string:

NSDateFormatter *dateFormatter = [[NSDateFormatter alloc] init];
[dateFormatter setDateFormat:@"ddMMyyyy"];
NSDate *date = [dateFormatter dateFromString:actualYearDate];
NSString *stringFromDate = [NSString stringFromDate:date];

And you can use this string. Date format you can choose as you want.

How to save date in sqlite tables?

1 Answers1