Problem with mysql YEAR_MONTH

[delamitri]

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

[pallevillesen]

It exists but your syntax is wrong.

 

mysql> select extract(year_month FROM curdate());

+------------------------------------+

| extract(year_month FROM curdate()) |

+------------------------------------+

|                             200301 |

+------------------------------------+

1 row in set (0.00 sec)



mysql> 

mysql> 

 

P., denmark

[delamitri]

hmm, entering this into phpmyadmin causes it to fall over.

 

When I type the query below, it does something very strange!!

 

SELECT * FROM reservations WHERE extract(year_month FROM date_departure) = extract(year_month FROM \'2002-12-02\')