Database format for timestamp

Random stuff about serendipity. Discussion, Questions, Paraphernalia.
Post Reply
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
Posts: 102
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

Post Reply