PHP and MySQL syntax: Difference between revisions

PHP and MySQL syntax (edit)

166 bytes added , 5 August 2014

m

14,983

edits

@@ Line 10: / Line 10: @@
 ** {{kbd | key=<nowiki>SELECT NOW()+0;</nowiki>}} //2011-04-01 12:19:43 returns 20110401122023.000000
 ** {{kbd | key=<nowiki>SELECT CURRENT_TIMESTAMP;</nowiki>}} /*return the human readable current time: 2011-04-01 12:19:43 */
-** {{kbd | key=<nowiki>SELECT current_date;</nowiki>}} /* Return {{CURRENTYEAR}}-{{CURRENTMONTH}}-{{CURRENTDAY2}} */
+** {{kbd | key=<nowiki>SELECT  CURRENT_DATE;</nowiki>}} /* Return {{CURRENTYEAR}}-{{CURRENTMONTH}}-{{CURRENTDAY2}} */<ref>[http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_curdate MySQL :: MySQL 5.5 Reference Manual :: 12.7 Date and Time Functions]</ref>
 * EXCEL: {{kbd | key=<nowiki>=TODAY()</nowiki>}} Returns the current date. ex: {{CURRENTYEAR}}/{{CURRENTMONTH}}/{{CURRENTDAY2}} <ref>[http://office.microsoft.com/en-gb/excel-help/today-function-HP010062297.aspx TODAY function - Excel - Office.com]</ref>