Find How many minutes a month has: MySQL

Question

Say I have a column

Date
23-03-2019
04-04-2019

I want to find hoe many minutes the whole month has in MySQL.

Expected output:

Date            MinsinMonth
23-03-2019       44640      
04-04-2019       43200

see : https://stackoverflow.com/questions/14642155/mysql-calculate-total-minutes — TheWildHealer, Apr 12 '19 at 10:51

score 3 · Answer 1 · answered Apr 12 '19 at 10:51

3

Basically, you just want to find the number of days in the month and then do some multiplication. For this, use last_day():

select day(last_day(date)) * 24 * 60 as minutes_in_month

answered Apr 12 '19 at 10:51

Gordon Linoff

score 2 · Accepted Answer · answered Apr 12 '19 at 10:52

2

This should work:

SELECT DAY(LAST_DAY(Date)) * 1440 AS MinsinMonth

LAST_DAY returns the last day in the month a date is in

DAY Returns the day number associated to a date

1440 is the number of minutes per day (60 * 24)

answered Apr 12 '19 at 10:52

vc 74

2 Answers2