PSQL use LIKE with timestamps

-- This throws the following error, being
-- updated's type timestamp with time zone
SELECT COUNT(*) FROM model WHERE updated LIKE '2021-10-17%';
ERROR:  operator does not exist: timestamp with time zone ~~ unknown

-- Cast timestamp to VARCHAR
SELECT COUNT(*) FROM amodel WHERE CAST(updated AS VARCHAR) LIKE '2021-10-17%';

Source: stackoverflow.com

Similar codes

1 vote328 views2 answers
How to add amount between date in sql
SQL
0 vote335 views1 answer
Tsql delete all rows
SQL
0 vote330 views1 answer
Null column as zero in mysql
SQL
3 votes318 views1 answer
Mysql replace string in table
SQL
3 votes341 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
1 vote353 views2 answers
Foreign key set 0
SQL
1 vote321 views1 answer
How to get mysql db size
SQL
0 vote333 views2 answers
Timing sql queries
SQL
0 vote336 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
0 vote326 views1 answer
Sql server python connection
SQL