15,047
edits
PHP and MySQL syntax: Difference between revisions
Jump to navigation
Jump to search
→specified time
| Line 52: | Line 52: | ||
** {{kbd | key==(A2-DATE(1970,1,1))*86400}} <ref>[http://stackoverflow.com/questions/1703505/excel-date-to-unix-timestamp Excel date to Unix timestamp - Stack Overflow]</ref> | ** {{kbd | key==(A2-DATE(1970,1,1))*86400}} <ref>[http://stackoverflow.com/questions/1703505/excel-date-to-unix-timestamp Excel date to Unix timestamp - Stack Overflow]</ref> | ||
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===TEXT(datevalue_cell,"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}} | ||