PHP and MySQL syntax: Difference between revisions

PHP and MySQL syntax (edit)

1 byte added , 5 August 2014

m

14,983

edits

@@ Line 6: / Line 6: @@
 the '''human readable''' time format ex: {{CURRENTYEAR}}-{{CURRENTMONTH}}-{{CURRENTDAY2}} {{CURRENTTIME}}:06
 * php: echo date("Y-m-d H:i:s", time() ); //Convert the time stamp of current time to the human readable time format. Ex: return '2010-12-21 10:05:06'
-* mysql: which mapping to DATETIME type<ref>[http://dev.mysql.com/doc/refman/5.1/en/datetime.html MySQL :: MySQL 5.1 Reference Manual :: 11.3.1 The DATE, DATETIME, and TIMESTAMP Types]</ref>
+* mysql:
-** {{kbd | key=<nowiki>SELECT NOW();</nowiki>}} /*return the human readable current time: 2011-04-01 12:19:43 */
+** {{kbd | key=<nowiki>SELECT NOW();</nowiki>}} /*return the human readable current time: 2011-04-01 12:19:43 */ which mapping to DATETIME type<ref>[http://dev.mysql.com/doc/refman/5.1/en/datetime.html MySQL :: MySQL 5.1 Reference Manual :: 11.3.1 The DATE, DATETIME, and TIMESTAMP Types]</ref>
 ** {{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 */