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 vote176 views1 answer
Events mysql
SQL
0 vote190 views1 answer
Postgres - Login and connect as default user
SQL
0 vote155 views1 answer
Java spring boot connect to sql server
SQL
0 vote159 views2 answers
Mysql create table if not exists
SQL
0 vote214 views1 answer
For select oracle
SQL
6 votes216 views3 answers
Rename column ORACLE
SQL
0 vote244 views1 answer
Get last inserted primary key
SQL
0 vote181 views1 answer
Mysql get date diff in months
SQL
0 vote135 views1 answer
Sqlalchemy existing database
SQL
-1 vote170 views1 answer
How to dump .csv file into mysql
SQL