Date date = new Date();
SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");;
String dateformat = simpleDateFormat.format(date);
String sql = " /*dialect*/ update " + tableName
+ " set CFBILLSTATUS=1 , FAUDITORID='"+id+"' , CFAUDITDATE=to_date('"+dateformat+"','YYYY-MM-DD HH24:MI:SS') where fid='" + billid + "' ";
boolean exeSQL = SQLFacadeFactory.getRemoteInstance().exeSQL(sql);