SELECT *
  FROM my_table
  WHERE datecol = DATE '2002-10-03';
---------------------------
SELECT *
FROM my_table
WHERE datecol = DATE '2002-10-03';