如何在mysql里格式化日期

下面的代码：

date_format(date,'%Y-%m-%d');

将把时间格式化为日期形式的字符串---（2007-03-16）

 

下面是从网上搜来的参数列表：

 

Example Date: 1st April 2005 Replace date with the name of your date field...
date_format String	Example
'%e/%c/%Y'	1/4/2005 UK
'%c/%e/%Y'	4/1/2005 US
'%d/%m/%Y'	01/04/2005 UK
'%m/%d/%Y'	04/01/2005 US
'%e/%c/%Y %H:%i'	1/4/2005 12:30 UK
'%c/%e/%Y %H:%i'	4/1/2005 12:30 US
'%d/%m/%Y %H:%i'	01/04/2005 12:30 UK
'%m/%d/%Y %H:%i'	04/01/2005 12:30 US
'%e/%c/%Y %T'	1/4/2005 12:30:10 UK
'%c/%e/%Y %T'	4/1/2005 12:30:10 US
'%d/%m/%Y %T'	01/04/2005 12:30:10 UK
'%m/%d/%Y %T'	04/01/2005 12:30:10 US
'%a %D %b %Y'	Fri 1st Apr 2005
'%a %D %b %Y %H:%i'	Fri 1st Apr 2005 12:30
'%a %D %b %Y %T'	Fri 1st Apr 2005 12:30:10
'%a %b %e %Y'	Fri Apr 1 2005
'%a %b %e %Y %H:%i'	Fri Apr 1 2005 12:30
'%a %b %e %Y %T'	Fri Apr 1 2005 12:30:10
'%W %D %M %Y'	Friday 1st April 2005
'%W %D %M %Y %H:%i'	Friday 1st April 2005 12:30
'%W %D %M %Y %T'	Friday 1st April 2005 12:30:10