截取Mysql的日期字段部分

来源： http://community.csdn.net/Expert/topic/5241/5241313.xml?temp=.9644739

 

select date_format('1997-10-04 22:23:00','%y %M %b %D %W %a %Y-%m-%d %H:%i:%s %r %T');

结果：97 October Oct 4th Saturday Sat 1997-10-04 22:23:00 10:23:00 PM 22:23:00

 

get_date = "2006-12-07"

SELECT count(*) FROM t_get_video_temp Where DATE_FORMAT(get_date, '%Y-%d')='2006-07';

 

SELECT count(*) FROM t_get_video_temp Where get_date like '2006%-07%';