How to calculate the number of minutes in a month?

Options

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

Tagged:

Best Answers

  • user08823
    user08823 Member
    Answer ✓
    Options

    Hi Apollo,

     

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

     

    Thanks!

  • Apollo
    Apollo Domo Employee
    Answer ✓
    Options

    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, 

    I work for Domo

Answers