delamitri Posted January 8, 2003 Share Posted January 8, 2003 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 Link to comment https://forums.phpfreaks.com/topic/27-problem-with-mysql-year_month/ Share on other sites More sharing options...
pallevillesen Posted January 9, 2003 Share Posted January 9, 2003 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 Link to comment https://forums.phpfreaks.com/topic/27-problem-with-mysql-year_month/#findComment-72 Share on other sites More sharing options...
delamitri Posted January 9, 2003 Author Share Posted January 9, 2003 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\') Link to comment https://forums.phpfreaks.com/topic/27-problem-with-mysql-year_month/#findComment-74 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.