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)
原文：https://www.cnblogs.com/mhabbyo/p/10592626.html