MysqlDataSource ds = new MysqlDataSource();
    ds.setServerName("myservername");
    ds.setUser("myusernamne");
    ds.setPassword("******");
    ds.setDatabaseName("mydbname");
    ds.setUseJDBCCompliantTimezoneShift(true);
    ds.setUseLegacyDatetimeCode(false);
    Connection con = ds.getConnection();
    PreparedStatement p = con.prepareStatement("select last_day('2014-01-15')");
    ResultSet rs = p.executeQuery();
    rs.next();
    Date date = rs.getDate(1);
    SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");
    System.out.println(df.format(date));

Calendar gmt = Calendar.getInstance(TimeZone.getTimeZone("GMT"));
rs.getDate(1, gmt);