select where time between psql 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'
column::text LIKE '2011-01-%'
SELECT * FROM data WHERE date = '2020-12-21'