PatPHP Posted October 13, 2009 Share 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. Quote Link to comment https://forums.phpfreaks.com/topic/177560-get-all-data-from-the-current-year/ Share on other sites More sharing options...
PFMaBiSmAd Posted October 13, 2009 Share Posted October 13, 2009 WHERE YEAR(your_date_column) = YEAR(curdate()) Beyond that, you would need to post what you did try if you want someone to help with why it did not work. Also, post an example of what data is in your column. Quote Link to comment https://forums.phpfreaks.com/topic/177560-get-all-data-from-the-current-year/#findComment-936225 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.