str_to_date

description

Syntax

DATETIME STR_TO_DATE(VARCHAR str, VARCHAR format)

通过format指定的方式将str转化为DATE类型，如果转化结果不对返回NULL。注意format指定的是第一个参数的格式。

支持date_format中的所有 format 格式，此外对于 ‘%Y’ 和 ‘%Y-%m’，支持补齐日期剩余部分。

example

1. mysql> select str_to_date('2014-12-21 12:34:56', '%Y-%m-%d %H:%i:%s');
2. +---------------------------------------------------------+
3. | str_to_date('2014-12-21 12:34:56', '%Y-%m-%d %H:%i:%s') |
4. +---------------------------------------------------------+
5. | 2014-12-21 12:34:56                                     |
6. +---------------------------------------------------------+

8. mysql> select str_to_date('2014-12-21 12:34%3A56', '%Y-%m-%d %H:%i%%3A%s');
9. +--------------------------------------------------------------+
10. | str_to_date('2014-12-21 12:34%3A56', '%Y-%m-%d %H:%i%%3A%s') |
11. +--------------------------------------------------------------+
12. | 2014-12-21 12:34:56                                          |
13. +--------------------------------------------------------------+

15. mysql> select str_to_date('200442 Monday', '%X%V %W');
16. +-----------------------------------------+
17. | str_to_date('200442 Monday', '%X%V %W') |
18. +-----------------------------------------+
19. | 2004-10-18                              |
20. +-----------------------------------------+

22. mysql> select str_to_date("2020-09-01", "%Y-%m-%d %H:%i:%s");
23. +------------------------------------------------+
24. | str_to_date('2020-09-01', '%Y-%m-%d %H:%i:%s') |
25. +------------------------------------------------+
26. | 2020-09-01 00:00:00                            |
27. +------------------------------------------------+

29. mysql> select str_to_date('2023','%Y');
30. +---------------------------+
31. | str_to_date('2023', '%Y') |
32. +---------------------------+
33. | 2023-01-01                |
34. +---------------------------+

keywords

1. STR_TO_DATE,STR,TO,DATE