mysql> select @@version_comment;
+----------------------------------------+
| @@version_comment |
+----------------------------------------+
| Doris version doris-2.1.8-1-834d802457 |
+----------------------------------------+
1 row in set (0.02 sec)
mysql> select
str_to_date('2025-04-17 00:00:18','yyyy-MM-dd HH:mm:ss'),
str_to_date('20250417000018','yyyyMMddHHmmss'),
str_to_date('20250417000018','%Y%m%d%H%i%s');
+-----------------------------------------------------------+-------------------------------------------------+-----------------------------------------------+
| str_to_date('2025-04-17 00:00:18', 'yyyy-MM-dd HH:mm:ss') | str_to_date('20250417000018', 'yyyyMMddHHmmss') | str_to_date('20250417000018', '%Y%m%d%H%i%s') |
+-----------------------------------------------------------+-------------------------------------------------+-----------------------------------------------+
| 2025-04-17 00:00:18.000000 | NULL | 2025-04-17 00:00:18.000000 |
+-----------------------------------------------------------+-------------------------------------------------+-----------------------------------------------+
1 row in set (0.03 sec)
mysql>
这个str_to_date('20250417000018','yyyyMMddHHmmss')
转换失败.