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

2 votes169 views1 answer
Find column in all stored procedures sql server
SQL
0 vote153 views1 answer
Soql user profile
SQL
2 votes223 views1 answer
Oracle list grants on package
SQL
15 votes140 views4 answers
How to get all tables in sql
SQL
10 votes152 views2 answers
Mysql drop database if exists
SQL
0 vote144 views1 answer
Add column in sql server ubuntu
SQL
6 votes151 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote153 views1 answer
Laravel migration sql dump
SQL
0 vote145 views1 answer
Nvl2 syntax
SQL
0 vote154 views1 answer
Look at running processes redshift
SQL