How to intepret the date in the database?

[Pauler221]

Checklist

• I made sure that there are no existing issues or discussions - open or closed - which I could contribute my information to.
• I have read the FAQ and my question isn't listed.
• I have taken the time to fill in all the required details. I understand that the question will be dismissed otherwise.
• I have read and understood the contribution guidelines.

What is/are your question(s)?

Hello, I'm trying to find a video I once watched. Since NewPipe doesn't allow you to search through your watch history I opened up the database to do it manually.

Now after inspecting "streams", "stream_history" and "search_history" closely I cannot intepret the "crearion_date" format. It's a 13 digit number that doesn't seem to represent a real date format.

I also want to sort the "search_history" and "streams" table by date.

Additional information

No response