Problem with mysql YEAR_MONTH

Hi all,

I have a problem with the YEAR_MONTH query in mysql, which is very bizzarre.

Having read the date/time functions on the mysql site, they say using YEAR_MONTH extracts the year an month from a given date field

a simple query should work:

SELECT YEAR_MONTH(CURDATE());

but get a mysql error.

tried

SELECT MONTH(CURDATE()) and also SELECT YEAR(CURDATE()) which both work fine, but just cannot use this YEAR_MONTH option.

I am using mysql 3.23.47, is this YEAR_MONTH thing not in this version or am I just doing something totally wrong here?

BTW even tried replacing CURDATE with NOW() and also a manual input of '2002-12-22', but all come up with the same error

Kevin

There is now function called YEAR_MONTH. It is a formatting parameter for the date functions.

Not quite right there. It is an interval type for the DATE_ADD and DATE_SUB functions.

Try -

DATE_FORMAT(CURDATE(),'%Y-%d')

Hope this helps 😉

What does this mean?

Does it mean it's only in a newer version of mysql, or should it work in my version?