Msyql日期字符串变换

Msyql日期字符串转换
Date和String的互相转换：http://www.tuicool.com/articles/iiQzeq
日志转换为字符串：DATE_FORMAT

mysql> use test;
Database changed
mysql> select DATE_FORMAT(now(),"%Y-%m-%d %H:%i:%s");
+----------------------------------------+
| DATE_FORMAT(now(),"%Y-%m-%d %H:%i:%s") |
+----------------------------------------+
| 2017-04-01 11:14:34                    |
+----------------------------------------+
1 row in set

字符串转换为日期：STR_TO_DATE

mysql> select STR_TO_DATE('2017-04-01',"%Y-%m-%d") ;
+--------------------------------------+
| STR_TO_DATE('2017-04-01',"%Y-%m-%d") |
+--------------------------------------+
| 2017-04-01                           |
+--------------------------------------+
1 row in set

mysql>