Date equality when no rows fit

Question

Accepted Answer

No row has event_date equal to '2024-03-10', so the result set is empty. Date equality filters are exact - the column value must match the literal precisely. This is a common gotcha when querying TIMESTAMP columns: if stored as '2024-03-10 09:00:00', the value does not equal the bare date '2024-03-10' cast to '2024-03-10 00:00:00'. When you're unsure whether any rows will match, a range query is safer than equality.