Date & Time Functions: Interview

Why are half-open timestamp ranges safer than casting a timestamp to a date?

A range such as timestamp >= start AND timestamp < next_day preserves index use, handles every time within the day, and avoids applying a function to each stored row.

Discuss timezone boundaries separately from the filtering pattern.