Ptt 大爆卦 | Overlap time - 前往 https://stackoverflow.com/questions/61672135/calculate-overlap-time-in-seconds-for-groups-in-sql

你即將離開本站

並前往https://stackoverflow.com/questions/61672135/calculate-overlap-time-in-seconds-for-groups-in-sql

Calculate overlap time in seconds for groups in SQL

In your example, the times completely cover the total duration. If this is always true, you can use the following logic:

確定！回上一頁

查詢「Overlap time」的人也找了：

時間重疊英文