15,047
edits
PHP and MySQL syntax: Difference between revisions
Jump to navigation
Jump to search
→now
(→now) |
(→now) |
||
| Line 10: | Line 10: | ||
** SELECT NOW()+0; //2011-04-01 12:19:43 returns 20110401122023.000000 | ** SELECT NOW()+0; //2011-04-01 12:19:43 returns 20110401122023.000000 | ||
** SELECT CURRENT_TIMESTAMP; /*return the human readable current time: 2011-04-01 12:19:43 */ | ** SELECT CURRENT_TIMESTAMP; /*return the human readable current time: 2011-04-01 12:19:43 */ | ||
* EXCEL: {{kbd | key=<nowiki>=TODAY()</nowiki>}} Returns the current date. ex: 2013/9/9 | * EXCEL: {{kbd | key=<nowiki>=TODAY()</nowiki>}} Returns the current date. ex: 2013/9/9 <ref>[http://office.microsoft.com/en-gb/excel-help/today-function-HP010062297.aspx TODAY function - Excel - Office.com]</ref> | ||
the current '''timestamp''' ex: 1292897201 | the current '''timestamp''' ex: 1292897201 | ||