当前位置: 技术问答>java相关
字符和时间我如何比较
来源: 互联网 发布时间:2015-07-07
本文导语: sql="Select from user where username='"; sql += session.getAttribute("UserName") +"' and month >= to_char('"+startDateQuery; sql += "','yyyymm') and month = to_date('"+startDateQuery; sql += "','yyyymm') and to_date(month,??????)
sql="Select from user where username='";
sql += session.getAttribute("UserName") +"' and month >= to_char('"+startDateQuery;
sql += "','yyyymm') and month = to_date('"+startDateQuery;
sql += "','yyyymm') and to_date(month,??????)
sql += session.getAttribute("UserName") +"' and month >= to_char('"+startDateQuery;
sql += "','yyyymm') and month = to_date('"+startDateQuery;
sql += "','yyyymm') and to_date(month,??????)