Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
menu search
person
Welcome To Ask or Share your Answers For Others

Categories

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


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
939 views
Welcome To Ask or Share your Answers For Others

1 Answer

等待大神答复

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
...