mysql – How do I know how many days are in the current month?

Question:

How to know how many days are in the current month MySQL, example: setembro = 30dias

Reason:

I have a goal: exemplo: 1.000,000

I need to take the target value and divide it by the number of days in the current month to return the daily target value.

Answer:

SELECT LAST_DAY(data)

I put it on GitHub for future reference .

Documentation .