14,983
edits
PHP and MySQL syntax: Difference between revisions
Jump to navigation
Jump to search
→Query by month
| Line 75: | Line 75: | ||
** SELECT * FROM `table_name` WHERE `time` >= '2014-01-01 00:00:00' AND `time` < '2014-02-01 00:00:00' | ** SELECT * FROM `table_name` WHERE `time` >= '2014-01-01 00:00:00' AND `time` < '2014-02-01 00:00:00' | ||
** SELECT * FROM `table_name` WHERE `time` >= '2014-01-01 00:00:00' AND `time` <= '2014-01-31 00:00:00' | ** SELECT * FROM `table_name` WHERE `time` >= '2014-01-01 00:00:00' AND `time` <= '2014-01-31 00:00:00' | ||
=== 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>}} sample output: {{CURRENTYEAR}}-{{CURRENTMONTH}}-{{CURRENTDAY}} | |||
=== further reading === | === further reading === | ||