Behind The Scenes: Core Data dates stored with 31 year offset?

by

Core Data stores dates relative to reference date, which is Jan 1st, 2001 (31 years after EPOCH as pointed out in the comments)

Here’s some code to decode the dates from the table, in case it is useful to you.

NSNumber *time = [NSNumber numberWithDouble:(d - 3600)];
NSTimeInterval interval = [time doubleValue];    
NSDate *online = [NSDate dateWithTimeIntervalSinceReferenceDate:interval];
NSDateFormatter *dateFormatter = [[NSDateFormatter alloc] init];
[dateFormatter setDateFormat:@"MM/dd/yyyy HH:mm:ss.SSS"];

NSLog(@"result: %@", [dateFormatter stringFromDate:online]);

https://developer.apple.com/library/mac/#documentation/Cocoa/Reference/Foundation/Classes/NSDate_Class/Reference/Reference.html

Take a look at + dateWithTimeIntervalSinceReferenceDate:

More Related Contents:

  1. Daylight saving time and time zone best practices [closed]
  2. Determine Whether Two Date Ranges Overlap
  3. Converting unix timestamp string to readable date
  4. Format current date and time in VBScript
  5. How do I convert a date/time string to a DateTime object in Dart?
  6. Kotlin DateTimeParseException
  7. Best way to store date/time in mongodb
  8. How to get the current time as datetime
  9. How to Convert UNIX epoch time to Date and time in ios swift
  10. What’s the difference between ISO 8601 and RFC 3339 Date Formats?
  11. How do you specify the date format used when JAXB marshals xsd:dateTime?
  12. Convert normal date to unix timestamp
  13. Convert 12-hour date/time to 24-hour date/time
  14. Why are date/time values interpreted incorrectly when patching/saving?
  15. Convert UTC string to time object
  16. Python Create unix timestamp five minutes in the future
  17. Check whether the string is a unix timestamp
  18. Parsing of Ordered Timestamps in Local Time (to UTC) While Observing Daylight Saving Time
  19. Pythonic way to combine datetime.date and datetime.time objects
  20. How to format a DateTime in PowerShell
  21. What is the difference between UTC and GMT?
  22. Aggregate Daily Data to Month/Year intervals
  23. IE JavaScript date parsing error
  24. Using DateTime properties in Code-First Entity Framework and SQL Server
  25. Best practices with saving datetime & timezone info in database when data is dependant on datetime
  26. How precise is the internal clock of a modern PC?
  27. Aggregating hourly data into daily aggregates
  28. Convert Unix timestamp to Java Date, Spring RequestParam
  29. How to convert epoch to datetime redshift?
  30. Twig date difference

Leave a Comment