2.1.8, str_to_date函数bug

Viewed 34

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')转换失败.

2 Answers

这种类型不支持,暂时不支持。我们内部跟进下,提个需求来处理
image.png

代用格式仅支持"yyyyMMdd", "yyyy-MM-dd", "yyyy-MM-dd HH:mm:ss"这三个。文档会进行修复:https://github.com/apache/doris-website/pull/2358