1 2 3 4 |
select DATE_FORMAT(create_time,'%Y%u') weeks,count(caseid) count from tc_case group by weeks; select DATE_FORMAT(create_time,'%Y%m%d') days,count(caseid) count from tc_case group by days; select DATE_FORMAT(create_time,'%Y%m') months,count(caseid) count from tc_case group by months; select DATE_FORMAT(create_time,'%Y') years,count(caseid) count from tc_case group by years; |
标签归档:MySQL
hibernate+MySQL中文乱码问题
用hibernate插入MySQL数据库时,发现如果字段含有中文时会变成"?",这是个乱码问题。