14,983
edits
PHP and MySQL syntax: Difference between revisions
Jump to navigation
Jump to search
m
→specified time
m (→specified time) |
|||
| Line 74: | Line 74: | ||
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('' | * Excel: {{kbd | key==DATEVALUE(''Cell_of_date'')}} // ex: {{kbd | key==DATEVALUE("2015/1/27")}} returns 42031. DATEVALUE of 1900/1/1 is 1 | ||
* Excel: {{kbd | key==TEXT('' | * Excel: {{kbd | key==TEXT(''Cell_of_datevalue'',"yyyy/mm/dd")}} // ex: {{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}} | ||