--写sql语句分别按日,星期,月,季度,年统计销售额
--按日
select sum(consume),day([date]) from consume_record where year([date]) = '' group by day([date])
--按周quarter
select sum(consume),datenam...
import java.util.Calendar;
import java.util.Date;
public class DateTest {
public static void main(String [] args){
Date now = new Date();
for(int i=0;i<9;i++){
Sy...