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

0 vote256 views2 answers
Return the number of records in a single table mysql
SQL
0 vote254 views1 answer
Find all tables where column name exists oracle
SQL
0 vote263 views1 answer
Sqlite version check
SQL
0 vote273 views1 answer
Sql how to get courses that i have made prerequisites
SQL
1 vote212 views1 answer
Unique vs distinct sql
SQL
19 votes258 views5 answers
Change column name mysql command line
SQL
0 vote285 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
0 vote254 views1 answer
Do postgresql
SQL
0 vote260 views1 answer
Odd record sql query
SQL
-2 votes264 views1 answer
No module named '_sqlite3
SQL