hql 转化日期类型

to_char(a.end_date,'yyyy-mm-dd') < to_char(a.actual_end_date,'yyyy-mm-dd')

to_date('"+NewDate+"','yyyy-mm-dd') > a.start_date

Date date = new Date();

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");  
String newdate = sdf.format(date);