sumic
新手上路
UID 97363
精华
0
积分 12
帖子 10
金钱 12 喜悦币
威望 0
人脉 0
阅读权限 10
注册 2007-8-22
状态 离线
|
[广告]: 代充Paypal帐号美元
DATE_FORMAT(date,format)
mysql> select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
-> 'Saturday October 1997'
mysql> select DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s');
-> '22:23:00'
mysql> select DATE_FORMAT('1997-10-04 22:23:00',
'%D %y %a %d %m %b %j');
-> '4th 97 Sat 04 10 Oct 277'
mysql> select DATE_FORMAT('1997-10-04 22:23:00',
'%H %k %I %r %T %S %w');
-> '22 22 10 10:23:00 PM 22:23:00 00 6'
例：select hour(datetime) as riqi,sum(number) as dianji from tb where date_format(datetime,'%Y-%m-%d')= '2006-03-31' group by hour(datetime);
|
|
