iOS Date (NSDate) in SQLite being read by Android

Question

From Android, I am reading SQLite3 Databases initially created from iOS (via NSDate). I can read the tables and values just fine, but there is a TIMESTAMP issue...

A TIMESTAMP field shows a numeric value, when viewed SQLite Database Browser. For example, the value of 385192800 is found in the database, which I believe corresponds to Sun March 17 2013, 6:00 AM UTC/GMT+0.

How can I interpret this date for Android (Java)? Typcially, timestamps should be the number of seconds (or even milliseconds) from 1970-01-01. This date is not even close...

When I issue the query below, I get "1982-03-16"...

SELECT strftime('%Y-%m-%d', datetime(385192800, 'unixepoch')) AS somedate 
FROM SOMETABLE LIMIT 1

It must not be a typical unix timestamp.. What does iOS's NSDate do, when persisting to SQLite3?

Didn't see the reference year of 2001. Spathi's link was also very helpful. — MiStr, Feb 01 '13 at 20:55

score 2 · Accepted Answer · edited May 23 '17 at 11:59

2

Core data stores timestamps based on the reference date, which is 1st Jan 2001. See this discussion for more information.

PS: Your question does not mention the year of the timestamp that you have specified.

edited May 23 '17 at 11:59

Community

1
1

answered Feb 01 '13 at 18:23

Spathi Wankenstein

196
8

Edit: Added the year (2013). Thanks! – MiStr Feb 01 '13 at 20:52

iOS Date (NSDate) in SQLite being read by Android

1 Answers1