NSTimeInterval timeStamp = 1282093277;
NSDate* date = [NSDate dateWithTimeIntervalSince1970:timeStamp];
NSLog(@”date=%@”, date); // date=2010-08-18 10:01:17 +0900
NSTimeInterval timeStamp = 1282093277;
NSDate* date = [NSDate dateWithTimeIntervalSince1970:timeStamp];
NSLog(@”date=%@”, date); // date=2010-08-18 10:01:17 +0900
NSDateFormatter *formatter = [[NSDateFormatter alloc] init];
[formatter setDateFormat:@"yyyy-MM-dd HH:mm:ss"]; //this is the sqlite's format
NSDate *date = [formatter dateFromString:aDateTime];