14,970
edits
Convert between date and unix timestamp: Difference between revisions
Jump to navigation
Jump to search
no edit summary
No edit summary |
|||
| Line 4: | Line 4: | ||
<tr> | <tr> | ||
<th> format \ date </th> | <th> format \ date </th> | ||
<th> 1900/1/0 | <th> 1899/12/31 (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 19: | Line 19: | ||
</tr> | </tr> | ||
<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 | <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 or LibreOffice [https://help.libreoffice.org/Calc/DATEVALUE/zh-TW DATEVALUE] function<br /> (Excel: number of days since 1898/12/31) </td> | ||
<td> 0</td> | <td> 0</td> | ||
<td> 1</td> | <td> 1</td> | ||
| Line 29: | Line 29: | ||
</div> | </div> | ||
{{exclaim}} [https://support.office.com/zh-tw/article/value-%E5%87%BD%E6%95%B8-257d0108-07dc-437d-ae1c-bc2d3953d8c2 VALUE()] function on Excel is number of days since 1900/1/1. [https://support.google.com/docs/answer/3094220?hl=en VALUE()] function on Google sheet is number of days since 1899/12/30 {{access | date=2019-05-22}} | {{exclaim}} [https://support.office.com/zh-tw/article/value-%E5%87%BD%E6%95%B8-257d0108-07dc-437d-ae1c-bc2d3953d8c2 VALUE()] function on Excel is number of days since 1899/12/31. DATEVALUE of 1900/1/1 will return 1. [https://support.google.com/docs/answer/3094220?hl=en VALUE()] function on Google sheet is number of days since 1899/12/30 {{access | date=2019-05-22}} | ||
== Convert between date and unix timestamp == | == Convert between date and unix timestamp == | ||