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


Recent - Timestamp convert to date and time



| 785301437 | 1055201551 | 178070837 | 337938882 | 6175229 | 1692506132 | 950290282 | 1319824918 | 594116622 | 363368167 | 1000994278 | 953559412 | 1592100011 | 1644202900 | 1228765807 | 654241238 | 1346405154 | 134272377 | 1758672100 | 89560594 | 578116205 | 519654963 | 916621206 | 1566664712 | 776509150 | 592703507 | 1073850764 | 147609897 | 647416264 | 565633038 | 618015614 | 1432717701 | 1620834589 | 796086451 | 1770656583 | 1627009818 | 341108935 | 573463217 | 799351088 | 935225558 | 936831385 | 1800345366 | 1888784970 | 381447748 | 1297064619 | 970067130 | 1035688986 | 495986125 | 1104339507 | 646877438 |

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