java代码:sql.append("AND  ta.FTrackDate>=to_date('"+begin+"','yyyy-MM-dd hh24:mi:ss ','NLS_DATE_LANGUAGE = American')
and ta.FTrackDate<to_date('"+end+"','yyyy-MM-dd hh24:mi:ss ','NLS_DATE_LANGUAGE = American')");

完整sql:

select tb.fid saleId,tb.FName_L2 saleName,count(ta.fid) followQty from T_SHE_CommerceChanceTrack  ta inner join t_pm_user tb on tb.fid=ta.FSaleManId

inner join T_SHE_CommerceChance tc on  tc.fid=ta.FCommerceChanceID

inner join T_SHE_SHECustomer td on tc.FCustomerID=td.fid

left join T_SHE_SellProject te on te.fid=ta.FSellProjectID

where ta.FSellProjectID='jv8AAABKx1kv++Ws' and  ta.FSaleManId in ('NAYILzT3RyuGUEAorCnl6hO33n8=','NAYILzT3RyuGUEAorCnl6hO33n8=','H/Gx6k81RMaKuVj22ezFNBO33n8=',

'IUtyUMGASmO5HI7bFLv10xO33n8=','KV8KTEZ8SNChsi78olOYbxO33n8=','MpejskvZR4mVkYhWU3ZQqxO33n8=','SQryFyomS5qaXjX0DLxxoRO33n8='

,'Uc9M/wcpQo672l4lCJgBGBO33n8=','lcCIKdYmRaOjQCAcjJPpMRO33n8=','GjrWREKMRhKcONvUw6gPTRO33n8=','yMJWzTOVQ+mGWxTMGK7ikBO33n8=')

AND  ta.FTrackDate>=to_date('2016-07-11 09:38:01','yyyy-MM-dd hh24:mi:ss ','NLS_DATE_LANGUAGE = American')

and ta.FTrackDate<to_date('2016-07-18 09:38:01','yyyy-MM-dd hh24:mi:ss ','NLS_DATE_LANGUAGE = American') group by tb.fid,tb.FName_L2

sql语句可以在oracle里面运行，但是数据就是传给不了前台