SQL select to_char(date,'yyyy-MM-dd') time from table(表名) where 条件
SQL查询可以使用to_char(time,'yyyy-MM-dd') 年-月-日
字符操作日期 to_date('2016-12-31','yyyy-MM-dd')
JAVA SimpleDateFormat formates = new SimpleDateFormat("yyyy-MM-dd");
String time = formates.formate(参数);
代码: String sql = "SELECT TO_CHAR(D.ID) ID,D.NAME AS NAME,D.CODE,D.SPEC_ID, D.CREATOR_ID,TO_CHAR(D.CREATE_DATE, 'yyyy-MM-dd HH24:Mi:SS') CREATEDATE,"
+ "D.MODIFIER_ID,D.MODIFY_DATE, D.TIME_STAMP,D.VERSION,D.SHARDING_ID,D.TYPE_ID TYPEID,D.STATUS_ID,A.NAME AS CREATOR "
+"FROM X_MOD_PROJECT D,PM_USER A WHERE A.ID = D.CREATOR_ID";
SimpleDateFormat formats = new SimpleDateFormat("yyyy-MM-dd HH:MM:SS"); //时间转换
if(param.get("code")!=null&&!"".equals(param.get("code"))){ //判断页面传来的值是否为空
sql = sql +" AND CODE = '"+param.get("code")+"'"; //拼接SQL查询
}
if(param.get("createDate")!=null&&!"".equals(param.get("createDate"))){
sql = sql +" AND D.CREATE_DATE >= to_date('"+formats.format(param.get("createDate"))+"', 'yyyy/MM/dd')";
}
if(param.get("toDate")!=null&&!"".equals(param.get("toDate"))){
sql = sql +" AND D.CREATE_DATE <= to_date('"+formats.format(param.get("toDate"))+"', 'yyyy/MM/dd')";
}
int count = (int) commonService.count(sql); //计算查出的页数