//数据库为mysql 用HQL语句查询比较时间
import java.util.Calendar;
Date date = new Date();
Calendar ca = Calendar.getInstance();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
//计算查询的时间间隔
ca.add(Calendar.DATE, -30);一个月内的订单
date = ca.getTime();
import java.util.Calendar;
Date date = new Date();
Calendar ca = Calendar.getInstance();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
//计算查询的时间间隔
ca.add(Calendar.DATE, -30);一个月内的订单
date = ca.getTime();
hql for mysql: "and m.createTime >='"+ sdf.format(date) +"' and m.createTime <= current_date() ";
注意:'"+ sdf.format(date) +"' 记住加上''单引号引上