如何在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