摘要:
下文讲述MySQL数据库中STR_TO_DATE函数的用法说明,如下所示;
STR_TO_DATE函数功能说明:
将一个任意格式的日期时间字符串
转换为一个DateTime数据
例:
mysql > select str_to_date('2020*9*30','%Y*%m*%d');
+-------------------------------------+
| str_to_date('2020*9*30','%Y*%m*%d') |
+-------------------------------------+
| 2020-09-30 |
+-------------------------------------+
1 row in set (0.00 sec)
mysql > select str_to_date('2020--9---30 12:9:54','%Y--%m---%d %H:%i:%s');
+------------------------------------------------------------+
| str_to_date('2020--9---30 12:9:54','%Y--%m---%d %H:%i:%s') |
+------------------------------------------------------------+
| 2020-09-30 12:09:54 |
+------------------------------------------------------------+
1 row in set (0.00 sec)