postgresql select datetime code example

Example 1: ilike for date postgres

column::text LIKE '2011-01-%'

Example 2: postgre query date

SELECT * FROM data WHERE date = '2020-12-21'