D
https://clickhouse.tech/docs/ru/operations/settings/settings/#settings-date_time_input_format
Size: a a a
D
V
<Information> ClusterCopier: There was an error while executing ALTER on each node. Query was executed on 4 nodes. But had to be executed on 153198686
DT
DT
D
DT
D
D
DT
D
D
V30LC-INCLKHSE1.PW.LOCAL :) select parseDateTimeBestEffort('10.11.2020');
SELECT parseDateTimeBestEffort('10.11.2020')
┌─parseDateTimeBestEffort('10.11.2020')─┐
│ 2020-11-10 00:00:00 │
└───────────────────────────────────────┘
1 rows in set. Elapsed: 0.007 sec.
DT
V30LC-INCLKHSE1.PW.LOCAL :) select parseDateTimeBestEffort('10.11.2020');
SELECT parseDateTimeBestEffort('10.11.2020')
┌─parseDateTimeBestEffort('10.11.2020')─┐
│ 2020-11-10 00:00:00 │
└───────────────────────────────────────┘
1 rows in set. Elapsed: 0.007 sec.
D
ДГ
D
D
PL
VA
D
AI
```SELECT name, price```
FROM subquery
WHERE (price) > (SELECT avg(price) FROM subquery)