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 vote192 views1 answer
Delete row mssql
SQL
2 votes253 views1 answer
Sqlite3 show columns name
SQL
0 vote245 views1 answer
How to input data as id in database sql c#
SQL
0 vote223 views1 answer
Load utilities in sql server
SQL
-1 vote207 views1 answer
How to open blade file from blade in laravel
SQL
0 vote262 views1 answer
Start stop mysql linux
SQL
0 vote203 views1 answer
Print boolean in plsql
SQL
12 votes191 views4 answers
Mysql get date difference in hours
SQL
0 vote192 views1 answer
Oracle sql log to console
SQL
1 vote209 views1 answer
Mysql dump specific tables
SQL