If you have similar 13-digit numbers and need to find their original date, you can use these methods:
WhatsApp often saves images or voice notes using the timestamp of when they were sent or downloaded. Download 1664246865848
This specific string is often seen as an auto-generated file name for downloads like WhatsApp media, browser screenshots, or system logs. If you are looking to manage or convert this type of data, here is the relevant content and tools you can use: GMT/UTC: Tuesday, September 27, 2022 2:47:45.848 AM Format: Unix Epoch Milliseconds If you have similar 13-digit numbers and need
Use the formula =(A1/86400000) + DATE(1970,1,1) where A1 is the cell containing the number. import datetime timestamp = 1664246865848 / 1000
import datetime timestamp = 1664246865848 / 1000.0 dt_utc = datetime.datetime.fromtimestamp(timestamp, datetime.timezone.utc) print(f"dt_utc=") Use code with caution. Copied to clipboard Timestamp to Date Converter | Free, Open Source & Ad-free
The number is a Unix timestamp (in milliseconds) that translates to Tuesday, September 27, 2022, at 02:47:45.848 UTC .