Msyql日期字符串转换

iteye_11587

于 2017-04-01 14:13:29 发布

阅读量82

点赞数

分类专栏： MySQL 文章标签： mysql

本文链接：https://blog.csdn.net/iteye_11587/article/details/82680841

版权

MySQL 专栏收录该内容

18 篇文章 0 订阅

订阅专栏

Date和String的互相转换：[url]http://www.tuicool.com/articles/iiQzeq[/url]
日志转换为字符串：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>