sql截取

String sql2="select count(*) from t_testuser where substr(INSETTIME,1,10)=to_char(sysdate,'yyyy-MM-dd') ";
ResultSet rs2=stmt.executeQuery(sql2);
 while(rs2.next()){ 
int count2=rs2.getInt(1); //本日新增体检用户数
  out.print(count2+";");

posted @ 2015-03-05 10:30  webnote  阅读(363)  评论(0编辑  收藏  举报