Unix Epoch Timestamp expressed in seconds and milliseconds. Click on the logo to copy the current value of timestamp to the clipboard.
What is timestamp
Timestamp is a number (or even other characters) that identifies a well-defined date and time in time.
In the specific case considered in this page, timestamp means the Unix Timestamp, i.e. the time expressed in seconds starting from January 1, 1970
So January 1, 1970 has the timestamp value of 0 (zero).
What is the timestamp for?
The timestamp is usually used in computer science to record the exact moment of a specific event. The timestamp is used extensively in database systems for example to record an event such as a payment, a posting date or the save date of an article.
A further use of the timestamp is to synchronize one or more computer systems.
The Timestamp in some programming languages
SELECT extract(epoch FROM now());
import time; time.time()