14,983
edits
PHP and MySQL syntax: Difference between revisions
Jump to navigation
Jump to search
→terms of time format
| Line 20: | Line 20: | ||
</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 /> (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> 1</td> | <td> 1</td> | ||
<td> 25569</td> | <td> 25569</td> | ||
| Line 28: | Line 28: | ||
</table> | </table> | ||
</div> | </div> | ||
{{exclaim}} {{kbd | key=<nowiki>VALUE()</nowiki>}} On Excel: number of days since 1900/1/1, On Google sheet: number of days since 1899/12/30 {{access | date=2019-05-22}} | |||
=== now === | === now === | ||