Unexpected behavior in DateTime64 handling

Issue: Inserting in a table correctly parses a formatted datetime string, but using the same string format for selecting fails.
Expected: either both fail (I hope not :) ) or both work.

https://fiddle.clickhouse.com/23946901-6458-429c-8d85-12acdaca69c0

```sql
set date_time_input_format='best_effort';

create table dd(x DateTime64(3)) engine=Memory;

insert into dd(x) values('2024-06-07 02:32:36.054-07') ;

select * from dd;

select * from dd where x>'2024-06-07 02:32:36.054-07';
```