HQL日期类型String转data类型 方言设置为mysql 用mysql内置函数

HQL日期类型String->data

String sql="from UnitRequirement po where str_to_date(po.publishTime,'%Y-%m-%d')>='"+time+"' and str_to_date(po.publishTime,'%Y-%m-%d')<'"+time1+"'";

示例：
select str_to_date('2008-4-2 15:3:28','%Y-%m-%d %H:%i:%s');
select str_to_date('2008-08-09 08:9:30', '%Y-%m-%d %h:%i:%s');