I would like to get the delta in hours between 8p.m. and 9 a.m based on a start_time and end_time.
It is like counting the delta in hours between two dates but taking only in account the hours between 8 p.m. and 9.am
for example:
start_date, end_date, result
2020-10-25 10:35:30, 2020-10-25 23:35:32, 3hours and 35 minutes (start counting at 8pm)
2020-10-25 08:14:37, 2020-10-25 20:14:37, approx 1 hour (from 8h14 to 9am + from 8pm to 8h14 )
2020-10-25 00:00:00, 2020-10-26 00:00:00, from 8pm to 9 am = (4+9 = 13 hours)
Thank you
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…