Date question

[hykc]

Hi

In my table, I have a field which is Date type
and the format is YYYY-MM-DD
if I want to search for particular year or month, what is the sql statement supposed to be?

thanks

[ultraslacker]

Use YEAR() and MONTH().

[hykc]

thanks