Tool to convert a timestamp. Timestamp is a number (or a character string) representing the date and time, usually with the number of seconds since Epoch.
Timestamp - dCode
Tag(s) : Date and Time, Informatics
dCode is free and its tools are a valuable help in games, maths, geocaching, puzzles and problems to solve every day!
A suggestion ? a feedback ? a bug ? an idea ? Write to dCode!
Timestamp
Timestamp to Date Converter
Date to Timestamp Converter
Current Unix Timestamp
Random Unix Timestamp
Answers to Questions (FAQ)
What is a timestamp? (Definition)
A timestamp is a numeric value indicating a number of units of time (usually seconds or milliseconds) that have elapsed since an initial date named Epoch, equal to 0.
How to calculate a timestamp?
A timestamp is calculated from the initial date. By default, each second after this date increments the timestamp with 1 unit.
The most popular Epoch is January 1, 1970 for Unix operating systems, Java programming languages, PHP, C ++, etc.
Epoch is January 6, 1980 for GPS (first Sunday of the year 1980)
Example: January 1, 2000 corresponds to 946681200 seconds after January 1, 1970 (Epoch Unix)
Some timestamps are more accurate than the second, each increment (called tick) can be of the order of milliseconds, microseconds or nanoseconds.
How to use a timestamp?
A timestamp allows comparison of two dates in an fast, exact and sure way. Indeed, with daylight saving time change, sometimes a 2h59 in the morning plus one minute, suddenly it is 2h00, the comparison of times is therefore difficult.
How to convert a timestamp?
dCode's converter allows to convert automatically by calculating exact days, months, years, hours, minutes and seconds (depending on the time zone).
How to convert a Date into a Unix Timestamp in Excel?
The dates in Excel have their own Epoch (January 0, 1900), the trick is to remove the one from Unix.
Example: For a date in cell A1: =(A1-DATE(1970,1,1))*86400
How to convert a Unix Timestamp into a Date in Excel?
The converting trick is to add the date Epoch of Unix/Linux =A1/86400+DATE(1970,1,1)
Why Epoch Unix is 1970-01-01?
January 1st, 1970 00:00 UTC is the start of UNIX era.
Windows systems (32 and 64 bits) use January 1st, 1601
What is going to happen on the january 19th, 2038?
On the 19/01/2038 at 03:14:07, the number of seconds since Epoch Unix will be 2147483647 seconds: 2^31-1, this is the size limit for 32bits systems. There will be a bug on the next second when calculating dates on these systems and all future dates will be considered in the past by the system.
Source code
dCode retains ownership of the "Timestamp" source code. Any algorithm for the "Timestamp" algorithm, applet or snippet or script (converter, solver, encryption / decryption, encoding / decoding, ciphering / deciphering, breaker, translator), or any "Timestamp" functions (calculate, convert, solve, decrypt / encrypt, decipher / cipher, decode / encode, translate) written in any informatic language (Python, Java, PHP, C#, Javascript, Matlab, etc.) or any database download or API access for "Timestamp" or any other element are not public (except explicit open source licence like Creative Commons). Same with the download for offline use on PC, mobile, tablet, iPhone or Android app.
Reminder: dCode is an educational and teaching resource, accessible online for free and for everyone.
Cite dCode
The content of the page "Timestamp" and its results may be freely copied and reused, including for commercial purposes, provided that dCode.fr is cited as the source.
Exporting the results is free and can be done simply by clicking on the export icons ⤓ (.csv or .txt format) or ⧉ (copy and paste).
To cite dCode.fr on another website, use the link:
In a scientific article or book, the recommended bibliographic citation is: Timestamp on dCode.fr [online website], retrieved on 2025-04-16,
- Timestamp to Date Converter
- Date to Timestamp Converter
- Current Unix Timestamp
- Random Unix Timestamp
- What is a timestamp? (Definition)
- How to calculate a timestamp?
- How to use a timestamp?
- How to convert a timestamp?
- How to convert a Date into a Unix Timestamp in Excel?
- How to convert a Unix Timestamp into a Date in Excel?
- Why Epoch Unix is 1970-01-01?
- What is going to happen on the january 19th, 2038?
