str_to_date

description

Syntax

DATETIME STR_TO_DATE(VARCHAR str, VARCHAR format)

通过format指定的方式将str转化为DATE类型，如果转化结果不对返回NULL

支持的format格式与date_format一致

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. +-----------------------------------------+

keyword

  1. STR_TO_DATE,STR,TO,DATE