MySql的DATE_FORMAT用法
摘要:
1 select DATE_FORMAT(create_time,'%Y%u') weeks,count(caseid) count from tc_case group by weeks; 2 select DATE_FORMAT(create_time,'%Y%m%d') days,count( 阅读全文
posted @ 2016-06-16 16:32 diguaer 阅读(8231) 评论(0) 推荐(0) 编辑