14,983
edits
PHP and MySQL syntax: Difference between revisions
Jump to navigation
Jump to search
m
→specified time
m (→specified time) |
m (→specified time) |
||
| Line 36: | Line 36: | ||
* mysql: SELECT UNIX_TIMESTAMP('2011-03-15 18:53:57'); /* return timestamp: 1300186437 */ | * mysql: SELECT UNIX_TIMESTAMP('2011-03-15 18:53:57'); /* return timestamp: 1300186437 */ | ||
* Excel: | * Excel: | ||
** date format of input (A2 cell): YYYY/MM/DD e.g. {{CURRENTYEAR}}/{{CURRENTMONTH}}/{{CURRENTDAY2}} | ** date format of input (A2 cell): YYYY/MM/DD or YYYY/MM/DD HH:MM e.g. {{CURRENTYEAR}}/{{CURRENTMONTH}}/{{CURRENTDAY2}} | ||
** {{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> | ||