且看如下：
select date_format(create_time,‘%Y.%m.%d‘),create_time from vs_article where article_id=‘20‘;
结果：
+-------------------------------------+---------------------+ | date_format(create_time,‘%Y-%m.%d‘) | create_time | +-------------------------------------+---------------------+ | 2014-12.17 | 2014-12-17 11:44:03 | +-------------------------------------+---------------------+ 1 row in set
原文：http://www.cnblogs.com/feijian/p/4189703.html