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 vote233 views1 answer
Mysql case when multiple conditions
SQL
3 votes261 views4 answers
Truncate syntax in sql
SQL
0 vote217 views1 answer
Delete double on SQL with multiple primary keys
SQL
0 vote220 views1 answer
Run postgresql dump to csv
SQL
0 vote223 views1 answer
Sql remove non numeric characters
SQL
0 vote217 views1 answer
How to reset AI in sql
SQL
0 vote220 views1 answer
Show table structure mysql console
SQL
0 vote226 views3 answers
Average salary in sql
SQL
0 vote221 views2 answers
How to find sql server agent jobs related to a database
SQL
1 vote231 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL