Range types are a godsend when you need to calculate things like overlapping or intersecting time/date ranges.

Can you give a real world example?

	▲	christophilus an hour ago \| parent [-]
		I think the examples here are pretty good: https://boringsql.com/posts/beyond-start-end-columns/