Convert between date and unix timestamp: Difference between revisions
Jump to navigation
Jump to search
(Created page with "=== terms of time format === <div style="width:100%; min-height: .01%; overflow-x: auto;"> <table border="1" class="wikitable sortable nowrap"> <tr> <th> format \ date </th...") |
mNo edit summary |
||
| Line 50: | Line 50: | ||
echo date('Y-m-d H:i:s', $timestamp) . PHP_EOL; // 2019-03-14 08:00:00 | echo date('Y-m-d H:i:s', $timestamp) . PHP_EOL; // 2019-03-14 08:00:00 | ||
</pre> | </pre> | ||
Excel way: convert to date from unix timestamp | |||
* [https://docs.google.com/spreadsheets/d/1mUPLWLdCHcN5Nr3CL2JWYfdYmy4JyiYClXD1kHMLZc4/edit?usp=sharing demo] | |||
== References == | == References == | ||
Revision as of 11:22, 24 July 2019
terms of time format
| format \ date | 1900/1/1 | 1970/1/1 | 2016/1/1 | notes |
|---|---|---|---|---|
| value of unix timestamp (the number of seconds since 1970/01/01[1]) |
-2209075200 | 0 | 1451606400 | |
| value of Excel DATEVALUE function (Excel: number of days since 1900/1/1) |
1 | 25569 | 42370 | 5 digit numbers after 1970/1/1 |
VALUE() function on Excel is number of days since 1900/1/1. VALUE() function on Google sheet is number of days since 1899/12/30 [Last visited: 2019-05-22]
Convert between date and unix timestamp
Online tool
PHP way: convert to date from unix timestamp
// timestamp: 1552521600
// Is equivalent to:
// 03/14/2019 @ 12:00am (UTC)
// 2019-03-14T00:00:00+00:00 in ISO 8601
// Thu, 14 Mar 2019 00:00:00 +0000 in RFC 822, 1036, 1123, 2822
// Thursday, 14-Mar-19 00:00:00 UTC in RFC 2822
// 2019-03-14T00:00:00+00:00 in RFC 3339
date_default_timezone_set("Europe/London");
$timestamp = 1552521600;
echo date('Y-m-d H:i:s', $timestamp) . PHP_EOL; // 2019-03-14 00:00:00
date_default_timezone_set("Asia/Taipei");
$timestamp = 1552521600;
echo date('Y-m-d H:i:s', $timestamp) . PHP_EOL; // 2019-03-14 08:00:00
Excel way: convert to date from unix timestamp