How to calculate the number of minutes in a month?

Does anyone know how to calculate the number of minutes in a month?

I need to calculate the number of minutes per month to deduct from them idle time also in minutes and get the percentage of accessibility of the environment.

 

Regards,
Rodion

Best Answers

  • user08823
    Accepted Answer

    Hi Apollo,

     

    I just solved this by:
    (DAYOFMONTH(LAST_DAY(`sys_created_on`))*1440)

     

    Thanks!

  • Apollo
    Accepted Answer

    Also you can just do:

    DAY(LAST_DAY(CURRENT_DATE()))

    This will give you the days of the current month. Then you can multiply it by 1440 to get minutes a day. 

    Thank you, 

Answers