What does date equality actually match?

Question

Accepted Answer

Comparing a date column to a date string with = works when the column is a DATE type. Both Alpha and Gamma have event_date matching '2024-01-15'. If event_date were a TIMESTAMP column, this equality would still work in PostgreSQL because '2024-01-15' is cast to '2024-01-15 00:00:00'. Events at any other time on Jan 15 would NOT match - use a range instead for timestamps.