Looking for a fast, accurate, and easy-to-use Unix timestamp converter? This Epoch time conversion tool helps you seamlessly convert Unix time to human-readable date formats — and vice versa — in seconds, milliseconds, and microseconds.
Epoch & Date Time Converter
Loading…
Unix time — also known as the Unix epoch, POSIX time, or Unix timestamp — represents the number of seconds that have passed since January 1, 1970, at midnight UTC (00:00:00Z). This starting point is referred to as Unix time 0 and is commonly expressed in ISO 8601 format as 1970-01-01T00:00:00Z.
Importantly, Unix time does not account for leap seconds.
While the term “epoch” technically refers to that exact starting moment, it’s often used more broadly to mean Unix time in general.
🔢 Common Time Units
Time Unit
Equivalent in Seconds
1 Minute
60 seconds
1 Hour
3,600 seconds
1 Day
86,400 seconds
1 Week
604,800 seconds
1 Month (avg)
2,629,743 seconds
1 Year (avg)
31,556,926 seconds
What Is a Unix Timestamp?
A Unix timestamp, also called epoch time or POSIX time, is the number of seconds that have passed since January 1, 1970 at 00:00:00 UTC. It’s widely used in programming, databases, operating systems, and APIs to represent a point in time in a standardized format.
Example:
Unix Time: 1718131200 → Human Time: 2024-06-12 00:00:00 UTC
/usr/bin/nawk 'BEGIN {print srand()}' Solaris doesn’t support date +%s, but the default seed value for nawk’s random-number generator is the number of seconds since the epoch.
long epoch = new java.text.SimpleDateFormat("MM/dd/yyyy HH:mm:ss").parse("01/01/1970 01:00:00").getTime() / 1000; Timestamp in seconds, remove ‘/1000’ for milliseconds.
VBScript/ASP
DateDiff("s", "01/01/1970 00:00:00", time field)More ASP
SELECT extract(epoch FROM date('2000-01-01 12:34')); With timestamp: SELECT EXTRACT(EPOCH FROM TIMESTAMP WITH TIME ZONE '2018-02-16 20:38:40-08'); With interval: SELECT EXTRACT(EPOCH FROM INTERVAL '5 days 3 hours');
SQLite
SELECT strftime('%s',timestring);
SQL Server
SELECT DATEDIFF(s, '1970-01-01 00:00:00', time field)
String date = new java.text.SimpleDateFormat("MM/dd/yyyy HH:mm:ss").format(new java.util.Date (epoch*1000)); Epoch in seconds, remove ‘*1000’ for milliseconds.
Lua
datestring = os.date([format[,epoch]])
VBScript/ASP
DateAdd("s", epoch, "01/01/1970 00:00:00")More ASP
FROM_UNIXTIME(epoch, optional output format) Default output format is YYY-MM-DD HH:MM:SS. If you need support for negative timestamps: DATE_FORMAT(DATE_ADD(FROM_UNIXTIME(0), interval -315619200 second),"%Y-%m-%d") (replace -315619200 with epoch) More MySQL
PostgreSQL
PostgreSQL version 8.1 and higher: SELECT to_timestamp(epoch);Source Older versions: SELECT TIMESTAMP WITH TIME ZONE 'epoch' + epoch * INTERVAL '1 second';
SQLite
SELECT datetime(epoch_to_convert, 'unixepoch'); or local timezone: SELECT datetime(epoch_to_convert, 'unixepoch', 'localtime');
Oracle PL/SQL
SELECT to_date('01-JAN-1970','dd-mon-yyyy')+(1526357743/60/60/24) from dual Replace 1526357743 with epoch.
SQL Server
DATEADD(s, epoch, '1970-01-01 00:00:00')
IBM Informix
SELECT dbinfo('utc_to_datetime',epoch) FROM sysmaster:sysdual;
Microsoft Excel / LibreOffice Calc
=(A1 / 86400) + 25569 Format the result cell for date/time, the result will be in GMT time (A1 is the cell with the epoch number). For other time zones: =((A1 +/- time zone adjustment) / 86400) + 25569.
Crystal Reports
DateAdd("s", {EpochTimeStampField}-14400, #1/1/1970 00:00:00#) -14400 used for Eastern Standard Time. See Time Zones.
date -d @1520000000 Replace 1520000000 with your epoch, needs recent version of ‘date’. Replace ‘-d’ with ‘-ud’ for GMT/UTC time.
Mac OS X
date -j -r 1520000000
PowerShell
Function get-epochDate ($epochDate) { [timezone]::CurrentTimeZone.ToLocalTime(([datetime]'1/1/1970').AddSeconds($epochDate)) }, then use: get-epochDate 1520000000. Works for Windows PowerShell v1 and v2
Other OS’s
Command line: perl -e "print scalar(localtime(epoch))" (If Perl is installed) Replace ‘localtime’ with ‘gmtime’ for GMT/UTC time.
