14,983
edits
PHP and MySQL syntax: Difference between revisions
Jump to navigation
Jump to search
→date format
| Line 77: | Line 77: | ||
=== date format === | === date format === | ||
* Use [http://www.w3schools.com/sql/func_date.asp MySQL DATE() Function]: {{kbd | key = <nowiki>DATE( time )</nowiki> | sample output: {{CURRENTYEAR}}-{{CURRENTMONTH}}-{{CURRENTDAY}} | ||
* Use [http://www.w3schools.com/sql/func_date_format.asp MySQL DATE_FORMAT() Function]: {{kbd | key = <nowiki>DATE_FORMAT( time, '%Y-%m-%d')</nowiki> | * Use [http://www.w3schools.com/sql/func_date.asp MySQL DATE() Function]: {{kbd | key = <nowiki>DATE( time )</nowiki>}} | ||
* Use [http://www.w3schools.com/sql/func_date_format.asp MySQL DATE_FORMAT() Function]: {{kbd | key = <nowiki>DATE_FORMAT( time, '%Y-%m-%d')</nowiki>}} | |||
=== further reading === | === further reading === | ||