17,088
社区成员
发帖
与我相关
我的任务
分享
select nvl(end_time,to_date('2015-01-1','yyyy-mm-dd')) from em_adc_reverse_order_info
where created_date < to_date(' 2016-06-12 17:23:51','yyyy-mm-dd hh24:mi:ss')
and end_time<to_date('2016-06-12 17:23:51','yyyy-mm-dd hh24:mi:ss')
and MOB_NUMBER in ('15713687371') and CORP_ACCOUNT = '471700013464'
and SERVICE_ID = 'ANM3911602' and RESULT_CODE = '0'
String sql = "select MOB_NUMBER from em_adc_reverse_order_info where created_date < to_date(' "
+sdf.format(dAfter)
+ "','yyyy-mm-dd hh24:mi:ss')"
+"and nvl(end_time,to_date('"
+sdf.format(dBefore)
+"','yyyy-mm-dd hh24:mi:ss'))>to_date('"
+sdf.format(dAfter)
+"','yyyy-mm-dd hh24:mi:ss')"
+ " and MOB_NUMBER in ("
+ mobnumber
+ ") and CORP_ACCOUNT = '"
+ corpaccount
+ "'"
+ " and SERVICE_ID = '"
+ serviceID
+ "' and RESULT_CODE = '0'";