ACCESS的数据库,ODBC连接的.
query="select * from main where '1'='1' and up_time between to_date('2001-01-01','yyyy-mm-dd') and to_date('2002-12-31','yyyy-mm-dd')";
也不行
query="select * from main where '1'='1' and up_time between to_date('2001-01-01','yyyy-mm-dd') and to_date('2002-12-31','yyyy-mm-dd')";
也不行
//''一定要加上
query="select * from main where '1'='1' and up_time >=#2001-01-01# and up_time <=#2002-12-31#";但up_time字段一定要是时间日期型啊。
query="select * from main where '1'='1' and up_time between #2001/01/01# and #2002/12/31#";