Snapchat birthday d...
 
Notifications
Clear all

Snapchat birthday date

oozetus
(@oozetus)
New Member

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

Quote
Topic starter Posted : 18/05/2021 10:44 pm
AmNe5iA
(@amne5ia)
Active Member

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.

ReplyQuote
Posted : 19/05/2021 12:47 pm
oozetus
(@oozetus)
New Member

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.

ReplyQuote
Topic starter Posted : 19/05/2021 5:09 pm
Share:
Share to...