Hello, I am working on a Snapchat account database (main.db).
In the "Friend" table, I find the friends of the account with 2 different timestamps:
addedTimestamp (Unix timestamp, it's ok)
birthday (example: 42949672964)
Does anyone know how to convert this to human date?
I have the corresponding date of birth for this friend, but I would like to verify the ages of other friends.
The smartphone used during the month of January 2020 is a SAMSUNG GT-i9060i with Android 4.4.
Thank you in advance
It's a value that represents both the day and month of someone's birthday but not the year. Convert the value into hex and you'll see it falls pretty cleanly into two int values. The first four bytes are the month, the last four bytes are the day.
Your example, 42949672964, as hex = A00000004. So Month is "A" which is 10 in Decimal. So October. Day is "4" which is 4 in Decimal. So I believe your example is 4th of October.
Hello Amnesia,
many thanks for your reply, i couldn't find the answer anywhere.
What a pity that there is no year.
Sure enough, it's October 4.
What a pity that there is not the year, but I guess the information is only there to celebrate a happy birthday to friends :).
Thank you again for your help.
