3 ms·
Quote: "Reading around it seems that Apple, in their infinite unique wisdom have decided to use dates starting from 1.1.2001 on iPhone so let’s see what happen
by unnouinceput 7y ago
Quote:
"Reading around it seems that Apple, in their infinite unique wisdom have decided to use dates starting from 1.1.2001 on iPhone so let’s see what happens if we add an offset ...."
This did put a smile on my face. The author forgets/doesn't know WhatsApp is Facebook's app, has nothing to do with Apple and the fact that he used this from an iPhone is irrelevant. On Android local /data/data WhatsApp's database is the same.
- unnouinceput 7y ago2nd smile, upon re-reading. Quote: "Let’s see what we’ve got. The below is my analysis based on the data I’ve found in the tables in my own DB and my inferences about it: 1. Z_PK — seems like a serial number..." Yup, it is a serial number. One those who dream SQL, like me, for past 20+ years, will also call it Primary Key. This article is getting better with every re-read :)
- gdgdgd 7y agoyou just put a smile on my face :) did you miss the last ~50 years of using unix timestamps on almost all platforms? for your reading enjoyment: https://developer.apple.com/documentation/foundation/nsdate https://developer.apple.com/documentation/foundation/nsdate https://developer.android.com/reference/java/sql/Timestamp.html https://developer.android.com/reference/java/sql/Timestamp.h...