利志分享
view_headline
开发工具箱
go教程
clickhouse教程
kafka教程
python教程
shell教程
原创杂文
开发工具箱
go教程
clickhouse教程
kafka教程
python教程
shell教程
原创杂文
clickhouse报错：DB::Exception: Cannot parse datetime: Cannot parse DateTime from String.
原创杂文 / 时间：2022-03-16 22:50:10 / 阅读：1239 / 分享：0
执行报错如下： ``` SELECT toDateTime('') Query id: 97e2d5ef-11cc-4960-9da3-a2bc930aa36f 0 rows in set. Elapsed: 0.102 sec. Received exception from server (version 20.3.10): Code: 41. DB::Exception: Received from 12.0.0.1:3306. DB::Exception: Cannot parse datetime: Cannot parse DateTime from String. ``` 原因：由于toDateTime里面的执行的值为空字符串才会报此错误。 下面报错： ``` SELECT toDate('') Query id: 689f761a-24c6-4dda-a344-307c108258a8 0 rows in set. Elapsed: 0.005 sec. Received exception from server (version 20.3.10): Code: 38. DB::Exception: Received from 127.0.0.1:3306. DB::Exception: Cannot parse date: value is too short: Cannot parse Date from String. ``` 原因：由于toDate里面的执行的值为空字符串才会报此错误
按时间分类
2022-04-22
2022-04-10
2022-03-26
2022-03-16
2022-03-08
2022-03-04
2022-02-27
2022-02-26
2022-02-19
2022-01-30
2022-01-23
2021-11-14
2021-11-06
2021-10-07
2021-09-21
2021-09-20
2021-09-15
2021-08-22
2021-08-13
2021-07-28
2021-06-17
2021-05-22
2021-04-23
2021-04-03
2021-03-07
2021-03-05
2021-03-04
2021-02-28
2021-02-21
2021-02-20