1600921064 The current Unix epoch time is

Convert epoch to human-readable date and vice versa

Tim e stamp to Human date reset [batch convert] Supports Unix timestamps in seconds, milliseconds, microseconds and nanoseconds.

Human date to Timestamp reset [batch convert] Input format: R FC 2822, D-M-Y, M/D/Y, Y-M-D, etc. Strip 'GMT' to convert to local time.



Press c to clear all forms.

Epoch dates for the start and end of the year/month/day

Show start & end of y ear m onth d ay



Yr Mon Day GMT Local time

Convert



Convert seconds to days, hours and minutes

S econds to days, hours, minutes

What is epoch time?

The Unix epoch (or Unix time or POSIX time or Unix timestamp) is the number of seconds that have elapsed since January 1, 1970 (midnight UTC/GMT), not counting leap seconds (in ISO 8601: 1970-01-01T00:00:00Z). Literally speaking the epoch is Unix time 0 (midnight 1/1/1970), but 'epoch' is often used as a synonym for Unix time. Some systems store epoch dates as a signed 32-bit integer, which might cause problems on January 19, 2038 (known as the Year 2038 problem or Y2038). The converter on this page converts timestamps in seconds (10-digit), milliseconds (13-digit) and microseconds (16-digit) to readable dates.

Human-readable time Seconds 1 hour 3600 seconds 1 day 86400 seconds 1 week 604800 seconds 1 month (30.44 days) 2629743 seconds 1 year (365.24 days) 31556926 seconds

How to get the current epoch time in ...

PHP time() More PHP Python import time; time.time() Source Ruby Time.now (or Time.new ). To display the epoch: Time.now.to_i Perl time More Perl Java long epoch = System.currentTimeMillis()/1000; Returns epoch in seconds. C# DateTimeOffset.Now.ToUnixTimeSeconds() (.NET Framework 4.6+/.NET Core), older versions: var epoch = (DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc)).TotalSeconds; Objective-C [[NSDate date] timeIntervalSince1970]; (returns double) or NSString *currentTimestamp = [NSString stringWithFormat:@"%f", [[NSDate date] timeIntervalSince1970]]; C++11 double now = std::chrono::duration_cast<std::chrono::seconds>(std::chrono::system_clock::now().time_since_epoch()).count(); Lua epoch = os.time([date]) VBScript/ASP See the examples AutoIT _DateDiff('s', "1970/01/01 00:00:00", _NowCalc()) Delphi Epoch := DateTimetoUnix(Now); Tested in Delphi 2010. R as.numeric(Sys.time()) Erlang/OTP erlang:system_time(seconds). (version 18+), older versions: calendar:datetime_to_gregorian_seconds(calendar:universal_time())-719528*24*3600. MySQL SELECT unix_timestamp(now()) More MySQL examples PostgreSQL SELECT extract(epoch FROM now()); SQLite SELECT strftime('%s', 'now'); Oracle PL/SQL SELECT (CAST(SYS_EXTRACT_UTC(SYSTIMESTAMP) AS DATE) - TO_DATE('01/01/1970','DD/MM/YYYY')) * 24 * 60 * 60 FROM DUAL; SQL Server SELECT DATEDIFF(s, '1970-01-01 00:00:00', GETUTCDATE()) IBM Informix SELECT dbinfo('utc_current') FROM sysmaster:sysdual; JavaScript Math.floor(new Date().getTime()/1000.0) The getTime method returns the time in milliseconds. Visual FoxPro DATETIME() - {^1970/01/01 00:00:00} Warning: time zones not handled correctly Go time.Now().Unix() More Go Adobe ColdFusion <cfset epochTime = left(getTickcount(), 10)> Tcl/Tk clock seconds Unix/Linux Shell date +%s Solaris /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. PowerShell [int][double]::Parse((Get-Date (get-date).touniversaltime() -UFormat %s)) Other OS's Command line: perl -e "print time" (If Perl is installed on your system)

Convert from human-readable date to epoch

Convert from epoch to human-readable date

PHP date(output format, epoch); Output format example: 'r' = RFC 2822 date, more PHP examples Python import time; time.strftime("%a, %d %b %Y %H:%M:%S +0000", time.localtime(epoch)) Replace time.localtime with time.gmtime for GMT time. Or using datetime: import datetime; datetime.datetime.utcfromtimestamp(epoch).replace(tzinfo=datetime.timezone.utc) Ruby Time.at(epoch) C# private string epoch2string(int epoch) {

return new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc).AddSeconds(epoch).ToShortDateString(); } Perl Use the Perl Epoch routines Java 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 AutoIT _DateAdd("s", $EpochSeconds , "1970/01/01 00:00:00") Delphi myString := DateTimeToStr(UnixToDateTime(Epoch)); Where Epoch is a signed integer. C Use the C Epoch Converter routines Objective-C NSDate * myDate = [NSDate dateWithTimeIntervalSince1970:epoch]; NSLog(@"%@", date); R as.POSIXct(epoch, origin="1970-01-01", tz="GMT") Go Example code Adobe ColdFusion DateAdd("s",epoch,"1/1/1970"); MySQL 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. JavaScript Use the JavaScript Date object Tcl/Tk clock format 1325376000 Documentation MATLAB datestr(719529+TimeInSeconds/86400,'dd-mmm-yyyy HH:MM:SS') IBM PureData System for Analytics select 996673954::int4::abstime::timestamp; Unix/Linux Shell 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.



Thanks to everyone who sent me corrections and updates!

More date related programming examples: What's the current week number? - What's the current day number?

Please note: All tools on this page are based on the date & time settings of your computer and use JavaScript to convert times. Some browsers use the current DST (Daylight Saving Time) rules for all dates in history. JavaScript does not support leap seconds.