How to calculate the number of minutes in a month?

user08823 · December 2017

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

user08823 · December 2017

Hi Apollo,

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

Thanks!

Apollo · December 2017

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,

Apollo · December 2017

Hi,

I found this Dojo article where they found a way to do this in beast mode. https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Is-there-a-way-to-calculate-the-total-days-in-the-month-we-are/m-p/14645#M1136

This calculates the number of days in a month that we are currently in. With that you can multiply it by 1440 which is how many minutes are in a day.

Thank you,

user08823 · December 2017

Hi Apollo,

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

Thanks!

Apollo · December 2017

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,

Magic ETL

Magic ETL

How to calculate the number of minutes in a month?

Welcome!

Best Answers

Answers

Welcome!

Welcome!

Quick Links

Categories