Get all data from the current year in MySQL Help Posted October 13, 2009 Hi Guys How can I get all the data from the current year??? I mean between 2009-01-01 and 2010-01-01??? I tried to do it with the time functions between year(curdate()) and year(curdate()) + 1. But this doesn't work. Thanks for your help.