Timestamp converter

Convert timestamp in date time value and vice versa

This tool convert epoch/unix timestamp in readable date time value and vice versa

Converters

4.9 Share

Timestamp to date time

CONVERT

Datetime to timestamp

CONVERT

What is timestamp or Epoch time?

How does it work?

Timestamp indicates a particular unit of measurement of time typical of computers based on UNIX architecture.

More precisely, the timestamp is an integer numeric value that expresses the number of seconds elapsed from an arbitrary date, ie midnight (UTC) of January 1, 1970, which is called epoch 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.

These converter of unix timestamp (Epoch converter) carry out the process of conversion of a date into a timestamp and vice versa.

Simply insert the timestamp you want to convert and click on the convert button.

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

Hot to get current epoch time in code languages

Let's diving into each examples

PHP	`time()`
Python	`import time; time.time()`
Ruby	`Time.now` (or `Time.new`). To display the epoch: `Time.now.to_i`
Perl	`time`
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])`
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())`
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()`
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)