Qunar Tech Salon

Apr 7, 2015 · Databases

Correct SQL Logic for Selecting Today's Records in PostgreSQL

The article explains why using a closed interval ending at 23:59:59 fails to capture the full day, and demonstrates the proper open‑closed interval technique—greater‑or‑equal to the day's start and less than the next day's start—using PostgreSQL examples.