15,030
edits
Convert between date and unix timestamp: Difference between revisions
Jump to navigation
Jump to search
m
→terms of time format
| Line 4: | Line 4: | ||
<tr> | <tr> | ||
<th> format \ date </th> | <th> format \ date </th> | ||
<th> 1900/1/0</th> | |||
<th> 1900/1/1</th> | <th> 1900/1/1</th> | ||
<th> 1970/1/1</th> | <th> 1970/1/1</th> | ||
| Line 12: | Line 13: | ||
<td> value of unix timestamp <br /> (the number of seconds since 1970/01/01<ref>[https://www.extendoffice.com/documents/excel/2473-excel-timestamp-to-date.html How to convert between date and Unix timestamp in Excel?]</ref>)</td> | <td> value of unix timestamp <br /> (the number of seconds since 1970/01/01<ref>[https://www.extendoffice.com/documents/excel/2473-excel-timestamp-to-date.html How to convert between date and Unix timestamp in Excel?]</ref>)</td> | ||
<td> -2209075200</td> | <td> -2209075200</td> | ||
<td> -2208988800</td> | |||
<td> 0</td> | <td> 0</td> | ||
<td> 1451606400</td> | <td> 1451606400</td> | ||
| Line 18: | Line 20: | ||
<tr> | <tr> | ||
<td> value of Excel [https://support.office.com/zh-tw/article/DATEVALUE-%E5%87%BD%E6%95%B8-df8b07d4-7761-4a93-bc33-b7471bbff252 DATEVALUE] function <br /> (Excel: number of days since 1900/1/1) </td> | <td> value of Excel [https://support.office.com/zh-tw/article/DATEVALUE-%E5%87%BD%E6%95%B8-df8b07d4-7761-4a93-bc33-b7471bbff252 DATEVALUE] function <br /> (Excel: number of days since 1900/1/1) </td> | ||
<td> 0</td> | |||
<td> 1</td> | <td> 1</td> | ||
<td> 25569</td> | <td> 25569</td> | ||