I did a search and all they showed was DATE_FORMAT being used in the SELECT part of the query. But I want to use DATE_FORMAT so it generalises the date column into the month.
Here is my query:
SELECT * FROM news WHERE DATE_FORMAT(news.thedate,'%Y-%d') = '2005-09';
Obviously, this is not working. The query goes through but no rows are returned. What can I do?
Never mind I got it. Parameters in mySQL are confusing. its '%Y-%m'
you might try %m (month) instead of %d (day)
This topic is now archived. It is frozen and cannot be changed in any way.