时间格式转换

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);  //计算查出的页数