mysql 时间格式转换 DATE_FORMAT

mysql> select DATE_FORMAT(now(),'%Y%m%d%H%i%s');
+-----------------------------------+
| DATE_FORMAT(now(),'%Y%m%d%H%i%s') |
+-----------------------------------+
| 20190325110933 |
+-----------------------------------+
1 row in set (0.00 sec)

posted @ 2019-03-25 11:11  mhabbyo  阅读(556)  评论(0编辑  收藏  举报