MySql Oracle 日期比较对比

来源：互联网发布：郑州景安网络怎么样编辑：程序博客网时间：2024/06/06 10:59

MySql:

if(!StringUtil.isEmpty(dateStart)){Date date = (Date)params.get("dateStart");SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");dateStart = sdf.format(date);sb.append(" AND FINAL.creation_date >= '"+dateStart+"'");}if(!StringUtil.isEmpty(dateEnd)){Date date = (Date)params.get("dateEnd");SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd 23:59:59");dateEnd = sdf.format(date);sb.append(" AND FINAL.creation_date <= '"+dateEnd+"'");}

Oracle:

if(!StringUtil.isEmpty(dateStart)){Date date = (Date)params.get("dataStart");SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");dataStart= sdf.format(date);sb.append(" AND FINAL.APPROVE_DATE <= to_date('"+dataStart+"','yyyy-mm-dd hh24:mi:ss')");}if(!StringUtil.isEmpty(dataEnd)){Date date = (Date)params.get("dataEnd");SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd 23:59:59");dataEnd= sdf.format(date);sb.append(" AND FINAL.APPROVE_DATE <= to_date('"+dataEnd+"','yyyy-mm-dd hh24:mi:ss')");}

阅读全文

1 0