How to get Current Year Data in MySQL?
by
Anuj Kumar
How to get Current Year Data in MySQL? We can use curdate() function to get today’s date and then use year() function on it to get the current year.
SELECT * FROM table_name WHERE date_column= year(curdate());
OR
We can CURRENT_DATE() function
SELECT * FROM table_name WHERE YEAR(date_column) = YEAR(CURRENT_DATE());
Tags: How to get Current Year Data in MySQL?
Anuj Kumar
Hi! I am Anuj Kumar, a professional web developer with 5+ years of experience in this sector. I found PHPGurukul in September 2015. My keen interest in technology and sharing knowledge with others became the main reason for starting PHPGurukul. My basic aim is to offer all web development tutorials like PHP, PDO, jQuery, PHP oops, MySQL, etc.
Apart from the tutorials, we also offer you PHP Projects, and we have around 100+ PHP Projects for you.
Recommended Tutorials for you
You may also like...
