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

49 votes312 views6 answers
Get duplicate records in sql
SQL
2 votes256 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote275 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
0 vote287 views4 answers
Restart MySQL
SQL
0 vote282 views1 answer
Mysql insert into select transaction c#
SQL
12 votes268 views10 answers
Google
SQL
0 vote267 views1 answer
Mysql utc timestamp
SQL
0 vote262 views1 answer
How to find sql server name
SQL
3 votes271 views2 answers
Mysql config user password
SQL
0 vote276 views1 answer
Mysql query to select the highest value
SQL