14,983
edits
PHP and MySQL syntax: Difference between revisions
Jump to navigation
Jump to search
m
→today & yesterday
| Line 75: | Line 75: | ||
</pre> | </pre> | ||
==== today | ==== today, yesterday or the day before yesterday ==== | ||
today | today | ||
* MySQL: {{kbd | key=<nowiki>SELECT CURRENT_DATE();</nowiki>}} or {{kbd | key=<nowiki>SELECT CURDATE();</nowiki>}} Returns {{Template:Today}} <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> | * MySQL: {{kbd | key=<nowiki>SELECT CURRENT_DATE();</nowiki>}} or {{kbd | key=<nowiki>SELECT CURDATE();</nowiki>}} Returns {{Template:Today}} <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> | ||