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 vote309 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
0 vote365 views1 answer
Sql server query all database objects
SQL
3 votes335 views1 answer
Laravel database Using Named Bindings
SQL
-1 vote334 views1 answer
Phinehas Psalm 106
SQL
49 votes391 views6 answers
Mysql add column to table
SQL
0 vote330 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
14 votes314 views3 answers
SQL trim
SQL
2 votes304 views1 answer
Apex date today add days
SQL
1 vote329 views1 answer
Quit mysql
SQL
0 vote360 views1 answer
Drop a view in sqlite
SQL