Capturing every timestamp in a single day

Question

Accepted Answer

For a TIMESTAMP column, = '2024-01-15' only matches midnight (00:00:00) exactly - rows at any other time are excluded. BETWEEN '2024-01-15 00:00:00' AND '2024-01-15 23:59:59' misses timestamps between 23:59:59 and midnight (e.g. 23:59:59.5). The half-open interval >= start AND < next_day captures all timestamps for the entire day without any gaps. DATE(created_at) = '2024-01-15' works but prevents index use on created_at in most databases.