string qs="select * from mytable where RECTIME between "+"'"+start+"'"+" and "+"'"+end+"'";
对与access应该是 string qs="select * from mytable where RECTIME between #"+start+"# and #"+end+" #"; sql server可以 string qs="select * from mytable where RECTIME between "+start+" and "+end+" ";
在Oracle 中最好先转换为字符,然后再 string qs="select * from mytable where RECTIME between '"+start+"' and "+"'"+end+"'";
start和end为时间类型。 string qs="select * from mytable where RECTIME between '"+start.ToShortDateString()+"' and "+"'"+end.ToShortDateString()+"'";
access: string qs="select * from mytable where RECTIME between #"+start+"# and #"+end+" #";oracle: string qs="select * from mytable where RECTIME between to_date("+start+",'yyyy-mm-dd hh24:mm:ss') and to_date("+end+", 'yyyy-mm-dd hh24:mm:ss')";
string qs="select * from mytable where RECTIME between '" + start.ToString(MM/dd/yyyy) + "' and '" + end.ToString("MM/dd/yyyy") + "'";
string qs="select * from mytable where RECTIME between #"+start+"# and #"+end+" #";
sql server可以
string qs="select * from mytable where RECTIME between "+start+" and "+end+" ";
(我用的是C#)
string qs="select * from mytable where RECTIME between '"+start+"' and "+"'"+end+"'";
string qs="select * from mytable where RECTIME between '"+start.ToShortDateString()+"' and "+"'"+end.ToShortDateString()+"'";
string qs="select * from mytable where RECTIME between #"+start+"# and #"+end+" #";oracle:
string qs="select * from mytable where RECTIME between to_date("+start+",'yyyy-mm-dd hh24:mm:ss') and to_date("+end+", 'yyyy-mm-dd hh24:mm:ss')";