15,047
edits
PHP and MySQL syntax: Difference between revisions
Jump to navigation
Jump to search
m
→specified time
m (→specified time) |
m (→specified time) |
||
| Line 54: | Line 54: | ||
convert [https://support.office.com/zh-tw/article/DATEVALUE-%E5%87%BD%E6%95%B8-df8b07d4-7761-4a93-bc33-b7471bbff252 datevalue] (number of days since 1900/1/1) ↔ to human-readable date | convert [https://support.office.com/zh-tw/article/DATEVALUE-%E5%87%BD%E6%95%B8-df8b07d4-7761-4a93-bc33-b7471bbff252 datevalue] (number of days since 1900/1/1) ↔ to human-readable date | ||
* Excel: {{kbd | key==DATEVALUE("2015/1/27")}} // Returns 42031. DATEVALUE of 1900/1/1 is 1 | * Excel: {{kbd | key==DATEVALUE("2015/1/27")}} // Returns 42031. DATEVALUE of 1900/1/1 is 1 | ||
* Excel: {{kbd | key | * Excel: {{kbd | key==TEXT(datevalue_cell,"yyyy/mm/dd")}} // {{kbd | key ==TEXT(42031,"yyyy/mm/dd")}} Returns 2015/1/27 | ||
convert month name to numeric date ex: {{CURRENTMONTHNAME}} {{CURRENTDAY}}, {{CURRENTYEAR}} -> {{CURRENTYEAR}}-{{CURRENTMONTH}}-{{CURRENTDAY}} | convert month name to numeric date ex: {{CURRENTMONTHNAME}} {{CURRENTDAY}}, {{CURRENTYEAR}} -> {{CURRENTYEAR}}-{{CURRENTMONTH}}-{{CURRENTDAY}} | ||