StringBuilder strSql = new StringBuilder();
strSql.append(" SELECT A.FILEOPSW4,A.FILEOPSW36,A.FILEOPSW1,to_char(A.FILEOPSW9,'yyyy-MM-dd') as FILEOPSW9_,");
strSql.append(" A.FILEOPSW5,A.FILEOPSW34,B.TAG20,A.FILEOPSW28,A.FILEOPSW6,FILEOPSW35,A.FILEOPSW13,");
strSql.append("( select PRODUCTNAME from FILEFUND where CUSTID=a.FILEOPSW42 and PRODUCTID=a.FILEOPSW43) ");
strSql.append(" as PRODUCTNAME,A.FILEOPSW41,A.FILEOPSW42,A.FILEOPSW43,a.FILEOPSW37,a.CALCELFLAG ");
strSql.append(" FROM FILEOPSW A,SWIFTDATA B WHERE A.FILEOPSW1=B.SWIFTSEQNO ");
strSql.append("order by a.FILEOPSW9 desc ");
第一行 to_char(A.FILEOPSW9,'yyyy-MM-dd') as FILEOPSW9 修改为 to_char(A.FILEOPSW9,'yyyy-MM-dd') as FILEOPSW9Extend