Metacat

    java.util.Date update = new java.util.Date();

    ParsePosition pos = new ParsePosition(0);

    update = formatter.parse(updateStr, pos);

    String dateString = formatter.format(update);

    sql.append("select docid, date_updated from xml_documents where ");

    sql.append("date_updated > ");

      StringBuffer sql = new StringBuffer();

      sql.append("update xml_replication set last_checked = to_date('");

      sql.append(dateString).append("', 'YY-MM-DD HH24:MI:SS')");

      pstmt = conn.prepareStatement(sql.toString());

      pstmt.executeUpdate();

      //conn.commit();