How do you know how many days are in the current month?

Question

How to know how many days is the current month Mysql, example: setembro = 30dias

Motive:

I have a goal : exemplo: 1.000,000

I need to take the value of the goal and divide by the amount of days you have in the current month to return the value of the daily goal.

Answer 1

SELECT LAST_DAY(data)

I put in the Github for future reference.

Documentation.

Answer 2

In this context it would use two functions, the CURDATE() to know the date of the day and the LAST_DAT() which returns the last day of the month from a date.

SELECT LAST_DAY( CURDATE() ) as DIAS_MES

KURDISH() - Documentation

LAST_DAY() - Documentation

Answer 3

Just supplementing the information, how the friend wants the number of days.

SELECT DAY(LAST_DAY( data_field )) as DIAS_MES;