oracle中date类型的比较

前端之家收集整理的这篇文章主要介绍了oracle中date类型的比较前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

字段dtCreatDates 在oracle中为DATE类型,java类中为DATE类型.


  1. private Date dtCreatDate;


现在从条件框返回一个格式为"2015-06-03"的String类型的字符串,在service中用sql语句进行日期的条件查询.


那么需要将string类型转换为日期类型,再与日期类型进行比较...


代码如下:


  1. Service:
  2. String hql = "SELECT COUNT(*) FROM Instructions ";
  3. hql =hql+where;

  1. String strStartDate=ParamUtil.getString(request,"strStartDate","");//格式为:2010-05-03
  2. String strEndDate=ParamUtil.getString(request,"strEndDate","");//格式为:2016-06-01
  3. if(!strStartDate.equals("")){
  4. tWhere+=" and dtCreatDate>=to_date('"+strStartDate+" 00:00:00','yyyy-mm-dd hh24:mi:ss')";
  5. }
  6. if(!strEndDate.equals("")){
  7. tWhere+=" and dtCreatDate<=to_date('"+strEndDate+" 23:59:59','yyyy-mm-dd hh24:mi:ss')";
  8. }
  1. int count = objSvr.getCount(tWhere);


打印的语句如下:

  1. WHERE intVirDel<>1 and dtCreatDate>=to_date('2016-06-01 00:00:00','yyyy-mm-dd hh24:mi:ss') and dtCreatDate<=to_date('2016-06-24 23:59:59','yyyy-mm-dd hh24:mi:ss')

猜你在找的Oracle相关文章