selecting month from DATE column

soapydave

My mysql table has a DATE field, where the values are stored YYYY-MM-DD.

I want to SELECT entries where the DATE column contains a certain MONTH, like

SELECT * from my_table WHERE DATE contains AUGUST

is this possible - it should be. If so, what is the syntax. The MySQL site only tells how to get date values in, not out.

Thanks,

Dave

Rodders

MySQL Date and Time functions

SELECT * from my_table WHERE MONTHNAME(DATE) = 'August'

Haven't tried it, but I think it'll work.

nnichols

try the following -

SELECT * FROM my_table WHERE DATE_FORMAT(DATE, %m)=08

For a full list of the DATE_FORMAT() options have a look in the manual.

Hope this helps. 😉

Wien

... MONTH(DATE)=8 ;

soapydave

Thanks for the quick response. I saw these things in the MySQL manual and in a book I've got but no examples. And I've run across things before where mixing PHP and MySQL you have to alter syntax to get them to work together.

Thanks again,

Dave