¹ØÓÚʱ¼ä¶ÎµÄSQL£¨Orcale¡¢SQL Server£©²éѯ

Ò»¡¢Orcale ʱµÄ²éѯ
String hql = "from SmsTemplate t where 1=1 ";
 if (model != null && !"".equals(model.getEndTimes())&& null!=model.getEndTimes() ) {
   SimpleDateFormat dateFm = new SimpleDateFormat("yyyy-MM-dd"); //¸ñʽ»¯µ±Ç°ÏµÍ³ÈÕÆÚ
   Date endt = model.getEndTimes();
   String dateTime = dateFm.format(endt);
   
   hql += " and t.endTimes<= to_date('" + dateTime+"' ,'yyyy-mm-dd')"; //×¢Òâµ¥ÒýºÅ
   //hql += " and t.endTimes<= to_date('" + dateTime+"' ,'yyyy-mm-dd HH24:mi:ss')";//´øʱ¡¢·Ö¡¢Ãë ×¢Òâ mi
//×¢£ºendTimesÔÚÊý¾Ý¿âÖÐʱDATEÐ͵Ä
  }
¶þ¡¢ÆÕͨSQL Server ²éѯ
DECLARE @dt DATETIME
DECLARE @dt2 DATETIME
SET @dt = '2008-07-24'
SET @dt2 = DATEADD(day, 1, @dt)
select @dt as dt, @dt2 as dt2
select * from meet_now where meetdate between CONVERT(datetime , @dt, 111 ) and convert(datetime , @dt2, 111 ) order by id
select * from meet_now where DATEDIFF(day, meetdate, @dt) = 0 order by id