you use: "...and controltime between '"+date1+"' and '"+date2+"'"
不知道你date1和date2这两个变量是什么型的,我想应该是java.sql.Date吧 你这样用,等于是调用了Date的toString()方法,出来的格式YYYY-MM-DD 如下: SELECT numbers FROM ehistory WHERE ownernum='20153' and controltime>'2003-01-01' and controltime<'2003-12-31'这样的sql是不对的 应该这样写: controltime>to_date('2003-01-01','YYYY-MM-DD') and controltime<to_date('2003-12-31','YYYY-MM-DD')或者controltime between to_date('2003-01-01','YYYY-MM-DD') and to_date('2003-12-31','YYYY-MM-DD')相应的java你自己写吧
"...and controltime between '"+date1+"' and '"+date2+"'"
你这样用,等于是调用了Date的toString()方法,出来的格式YYYY-MM-DD
如下:
SELECT numbers FROM ehistory WHERE ownernum='20153' and
controltime>'2003-01-01' and controltime<'2003-12-31'这样的sql是不对的
应该这样写:
controltime>to_date('2003-01-01','YYYY-MM-DD') and
controltime<to_date('2003-12-31','YYYY-MM-DD')或者controltime between to_date('2003-01-01','YYYY-MM-DD')
and to_date('2003-12-31','YYYY-MM-DD')相应的java你自己写吧