hibernate查询日期Date传参

1、传String，将String转成"yyyy-MM-dd hh:mm:ss"格式。

2、sql里用to_char 函数来比较大小。

nowDateGet = nowDateGet.replace("T"," ");
      nowDate = StringUtil.dateFormat("yyyy-MM-dd hh:mm:ss", nowDateGet);

hql.append(" and to_char(clickTime,'yyyy-MM-dd hh24:mi:ss') >= ? and to_char(clickTime,'yyyy-MM-dd hh24:mi:ss') <= ? ");

public static String dateFormat(String format, String time) {
    try {
      SimpleDateFormat sdf = new SimpleDateFormat(format);
      java.util.Date date = sdf.parse(time);
      return sdf.format(date);
    } catch (Exception e) {
      return "";
    }
  }