PHP and MySQL syntax: Difference between revisions
Jump to navigation
Jump to search
→Date interval
mNo edit summary |
|||
| Line 252: | Line 252: | ||
* SELECT * FROM `table_name` WHERE `time` BETWEEN '{{Template:Today}} 00:00:00' AND '{{Template:Today}} 23:59:59' | * SELECT * FROM `table_name` WHERE `time` BETWEEN '{{Template:Today}} 00:00:00' AND '{{Template:Today}} 23:59:59' | ||
* SELECT * FROM `table_name` WHERE DATE(`time`) = '{{Template:Today}}' | * SELECT * FROM `table_name` WHERE DATE(`time`) = '{{Template:Today}}' | ||
=== Days before === | |||
[[Days before]] | |||
=== date format === | === date format === | ||