Timestamp converter

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

Timestamp to date time

Datetime to timestamp

What is timestamp or Epoch time?

What about unix epoch time?

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())-719528*24*3600.

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)

Share this tool

Did u like it? Share it!

Related tools

Try these one!
Build your Google campaign url

GOOGLE URL BUILDER

Build your Google Campaign Url for better tracking.

Add UTM parameters and track Custom Campaigns in Analytics account.

Go Build
Build your Google map

GOOGLE MAP BUILDER

Choose a map theme or build your custom Google map.

Customize maps with your own creativity, settings, styles and colors.

Go Build
Google Event Tracking Builder

GOOGLE EVENT BUILDER

Measure and track user interactions with your contents.

Track all the actions you want: downloads, clicks, video plays, social share, engagement.

Go Build
Google Mail Tracker

GOOGLE MAIL TRACKER

Create Analytics trackable URL and track email opens.

Send your email campaign and get data when user open your email.

Go Build