Answered by : cautious-chipmunk-3pu9xfdeiqis

SELECT *
FROM table
WHERE update_date >= '2013-05-03'::date
AND update_date < ('2013-05-03'::date + '1 day'::interval);

Source : https://stackoverflow.com/questions/19469154/how-to-compare-dates-in-datetime-fields-in-postgresql | Last Update : Thu, 02 Jul 20