sql这样写: String reqdate="2002-11-11"; String sql="select issue_time from platform_paper where to_char(issue_time,'YYYY-MM-DD')>'"+reqdate+"'";
不应该用to_char,应该用to_date把参数转换成日期,做比较条件更准确: String sql="select issue_time from platform_paper where issue_time>to_date('"+reqdate+"','yyyy-MM-dd hh:mm:ss')"; 再试试
java.util.Date reqdate=new java.util.Date("2002-11-11"); String sql="select issue_time from platform_paper where to_date(issue_time,'yyyy-MM-dd')>'"+reqdate+"'";
java.util.Date reqdate=new java.util.Date("2002-11-11"); String sql="select issue_time from platform_paper where to_date(issue_time,'yyyy-MM-dd')>"+reqdate;
oracle中如下
to_char('2002-11-11','YYYY-MM-DD')
String reqdate="2002-11-11";
String sql="select issue_time from platform_paper where to_char(issue_time,'YYYY-MM-DD')>'"+reqdate+"'";
String sql="select issue_time from platform_paper where issue_time>to_date('"+reqdate+"','yyyy-MM-dd hh:mm:ss')";
再试试
String sql="select issue_time from platform_paper where to_date(issue_time,'yyyy-MM-dd')>'"+reqdate+"'";
String sql="select issue_time from platform_paper where to_date(issue_time,'yyyy-MM-dd')>"+reqdate;