Epoch & Unix Timestamp Conversion Tools

1590000085

Convert epoch to human-readable date and vice versa

Prefer a 24-hour clock? Go to preferences.
Press c to clear all forms.

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

Convert seconds to days, hours and 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;`
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())-719528243600.`
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

PHP	`strtotime("15 November 2018")` (converts most English date texts) or: `date_create('11/15/2018')->format('U')` (using DateTime class) More PHP
Python	`import calendar, time; calendar.timegm(time.strptime('2000-01-01 12:34:00', '%Y-%m-%d %H:%M:%S'))`
Ruby	`Time.local(year, month, day, hour, minute, second, usec )` (or `Time.gm` for GMT/UTC input). To display add `.to_i`
Perl	Use the Perl Epoch routines
Java	`long epoch = new java.text.SimpleDateFormat("MM/dd/yyyy HH:mm:ss").parse("01/01/1970 01:00:00").getTime() / 1000;`
VBScript/ASP	`DateDiff("s", "01/01/1970 00:00:00", time field)` More ASP
AutoIT	`_DateDiff('s', "1970/01/01 00:00:00", "YYYY/MM/DD HH:MM:SS")`
Delphi	`Epoch := DateTimeToUnix(StrToDateTime(myString));`
C	Use the C Epoch Converter routines
R	`as.numeric(as.POSIXct("YYYY-MM-dd HH:mm:ss", tz = "GMT", origin="1970-01-01"))` The origin parameter is optional
Go	Example code
Adobe ColdFusion	`int(parseDateTime(datetime).getTime()/1000);`
MySQL	`SELECT unix_timestamp(time)` Time format: YYYY-MM-DD HH:MM:SS or YYMMDD or YYYYMMDD More on using Epoch timestamps with MySQL
PostgreSQL	`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)`
JavaScript	Use the JavaScript Date object
Unix/Linux Shell	`date +%s -d"Jan 1, 1980 00:00:01"` Replace '-d' with '-ud' to input in GMT/UTC time.

Convert from epoch to human-readable date

0%

10%

20%

30%

40%

50%

60%

70%

80%

90%

100%

Yr	Mon	Day
-	-

Hr	Min	Sec
:	:

Yr	Mon	Day
-	-