Timestamp convert to date and time

This is website where you can convert timestamp number to readable date and time format.What is Unix TimeStamp? The unix time stamp is a way to track time as a running total of seconds. This count starts at the Unix Epoch on January 1st, 1970. Therefore, the unix time stamp is merely the number of seconds between a particular date and the Unix Epoch. This is very useful to computer systems for tracking and sorting dated information in dynamic and distributed applications both online and client side.

Index | Recent Converted | Current Timestamp | Contact | Binary To Decimal

Timestamp convert to date and time

Convert timestamp to date and time

Insert Timestamp

Timestamp limit is 2147483647 so please choose lower value.

Convert date and time to timestamp

Select date from January 1 1970 to January 19 2038
Date - Year: / Month: / Day:
Time (UTC) - Hours: / Minutes: / Seconds:

1493464858 is Current Timestamp

Date and Time Formats
April 29, 2017, 11:20 am


29, 4, 2017


it is the 29th day.

Sat Apr 29 11:20:58 UTC 2017


2017-04-29 11:20:58

Timestamp number convert
Timestamp Binary format

Timestamp Octal format

Timestamp Hexadecimal format

Timestamp Hexatrigesimal format

Timestamp Barcode format
1493464858 timestamp barcode
1493464858 timestamp barcode
Convert 1493464858 to other numeral systems
Next and Previous 10 seconds
Previous 10 seconds
- 1493464848 Timestamp - 1493464849 Timestamp - 1493464850 Timestamp - 1493464851 Timestamp - 1493464852 Timestamp - 1493464853 Timestamp - 1493464854 Timestamp - 1493464855 Timestamp - 1493464856 Timestamp - 1493464857 Timestamp -
Next 10 seconds
- 1493464859 Timestamp - 1493464860 Timestamp - 1493464861 Timestamp - 1493464862 Timestamp - 1493464863 Timestamp - 1493464864 Timestamp - 1493464865 Timestamp - 1493464866 Timestamp - 1493464867 Timestamp - 1493464868 Timestamp -

Get current timestamp in...

PHP time()

Python import time; time.time()

Ruby Time.now (or Time.new). To display the timestamp: Time.now.to_i

Perl time

Java long epoch = System.currentTimeMillis()/1000;

C# var epoch = (DateTime.UtcNow - new DateTime(1970, 1, 1)).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::system_clock::now().time_since_epoch()).count();

VBScript/ASP DateDiff("s", "01/01/1970 00:00:00", Now())

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 (SYSDATE - TO_DATE('01/01/1970 00:00:00', 'MM-DD-YYYY HH24:MI:SS')) * 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.round(new Date().getTime()/1000.0) getTime() returns time in milliseconds.

Visual FoxPro DATETIME() - {^1970/01/01 00:00:00} Warning: time zones not handled correctly

Go time.Now().Unix()

Tcl/Tk clock seconds

Unix/Linux Shell date +%s

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 timestamp

PHP strtotime("15 November 2012") (converts most English date texts) or:
date_create('01/15/2010')->format('U') (PHP5 DateTime class)

Python import time; int(time.mktime(time.strptime('2000-01-01 12:34:00', '%Y-%m-%d %H:%M:%S'))) - time.timezone

Ruby Time.local(year, month, day, hour, minute, second, usec ) (or Time.gm for GMT/UTC input). To display add .to_i

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)

AutoIT _DateDiff('s', "1970/01/01 00:00:00", "YYYY/MM/DD HH:MM:SS")

Delphi Epoch := DateTimeToUnix(StrToDateTime(myString));

R as.numeric(as.POSIXct("MM/dd/yyyy HH:mm:ss", origin="1970-01-01"))

MySQL SELECT unix_timestamp(time) Time format: YYYY-MM-DD HH:MM:SS or YYMMDD or YYYYMMDD

PostgreSQL SELECT extract(epoch FROM date('2000-01-01 12:34'));
With timestamp: SELECT EXTRACT(EPOCH FROM TIMESTAMP WITH TIME ZONE '2001-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)

Unix/Linux Shell date +%s -d"Jan 1, 1980 00:00:01" Replace '-d' with '-ud' to input in GMT/UTC time.

Convert from timestamp to human readable date

PHP date(output format, epoch); Output format example: 'r' = RFC 2822 date

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.

Ruby Time.at(epoch)

C# private string epoch2string(int epoch) {
return new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc).AddSeconds(epoch).ToShortDateString(); }

Java String date = new java.text.SimpleDateFormat("MM/dd/yyyy HH:mm:ss").format(new java.util.Date (epoch*1000));

VBScript/ASP DateAdd("s", epoch, "01/01/1970 00:00:00")

AutoIT _DateAdd("s", $EpochSeconds , "1970/01/01 00:00:00")

Delphi myString := DateTimeToStr(UnixToDateTime(Epoch)); Where timestamp is a signed integer.

Objective-C NSDate * myDate = [NSDate dateWithTimeIntervalSince1970:epoch]; NSLog(@"%@", date);

R as.POSIXct(epoch, origin="1970-01-01", tz="GMT")

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)

PostgreSQL PostgreSQL version 8.1 and higher: SELECT to_timestamp(epoch);
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')+(1326357743/60/60/24) from dual Replace 1326357743 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 =(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.

Tcl/Tk clock format 1325376000

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 @1190000000 Replace 1190000000 with your epoch, needs recent version of 'date'. Replace '-d' with '-ud' for GMT/UTC time.

PowerShell Function get-epochDate ($epochDate) { [timezone]::CurrentTimeZone.ToLocalTime(([datetime]'1/1/1970').AddSeconds($epochDate)) }, then use: get-epochDate 1279152364. 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.

Timestampconvert.net 2016
Timestamp convert to date and time
What happens on January 19, 2038?
On this date the Unix Time Stamp will cease to work due to a 32-bit overflow. Before this moment millions of applications will need to either adopt a new convention for time stamps or be migrated to 64-bit systems which will buy the time stamp a "bit" more time. - Source Unixtimestamp.com
Everything you find on this website is for educational purpose. This website does not store any of your data.
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

We don't use cookies and other stuff. We don't have database. We just want to convert timestamp :) - By John

Privacy Policy