Filter query by date in PostgreSQL

This is how PostgreSQL is different from MySQL. You have to cast the date string using ::date

SELECT field FROM table WHERE some_date >= '2024-03-28'::date;