Project

General

Profile

« Previous | Next » 

Revision 47091

Added by Tsampikos Livisianos about 7 years ago

fix max timestamp

View differences:

modules/dnet-openaire-usage-stats-export/trunk/src/main/java/eu/dnetlib/usagestats/export/SushiStats.java
156 156 

  		




  157
  157
  
    
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");


  		




  158
  158
  
    
        PreparedStatement st = conn.prepareStatement("SELECT max(date) FROM public.sushilog WHERE repository=?;");


  		




  159
  
  
    
        st.setString(1, opendoar);


  		




  
  159
  
    
        st.setString(1, "opendoar____::" + opendoar);


  		




  160
  160
  
    
        ResultSet rs_date = st.executeQuery();


  		




  161
  161
  
    
        while(rs_date.next()){


  		




  162
  162
  
    
            if(rs_date.getString(1) != null && !rs_date.getString(1).equals("null") && !rs_date.getString(1).equals("")) {


  		












Also available in:  Unified diff