MySQL date functions that help you directly get required part of date. Commonly used MySQL date functions. These MySQL date functions are easy to remember.
month
Get current year, current month and current day in MySQL
Here are a few commonly used commands to find current year, current month and current day in MySQL. You can use date format is different variations for it.