Database format for timestamp

Random stuff about serendipity. Discussion, Questions, Paraphernalia.
Post Reply
KristyStevens
Posts: 1
Joined: Tue Jun 25, 2019 5:30 am

Database format for timestamp

Post by KristyStevens » Tue Jun 25, 2019 5:35 am

What is the format for generating the numbers in the database field for entry time stamps?

For instance what would "1123069245" translate to in real time?

User avatar
erAck
Regular
Posts: 93
Joined: Mon Feb 16, 2015 2:20 am

Re: Database format for timestamp

Post by erAck » Tue Jun 25, 2019 1:46 pm

Seconds since epoch (1970-01-01T00:00:00Z).

date -Is -d @1123069245
2005-08-03T13:40:45+02:00

Post Reply